I have a Userform Made. I need the code to call it with a togglebutton on the spreadsheet.
then I need the code that completes the Hyperlink as explained below.
LABEL<PROJ>TEXTBOX<ENTER PROJ NUMBER HERE> COMMANDBUTTON<HYPERLINK ACTIVATE>
I just need whatever is in the textbox to complete the hyperlink.
PREFIX "http://abc.mycmpny.com/abc_drw/qr/"&"textbox data".

http://abc.mycmpny.com/abc_drw/qr/049410-001
Commandbutton activate link.