Hello all
I'm trying to get a Dynamic Hyperlink added to sheet based on UserForm Textbox 6 The hyperlink links to FEDEX Tracking. is it possible to fix the below code to work.
Textbox6 will be the Tracking number this will make the Link to FedEx tracking directly to FedEx.
Any help is greatly appreciated
I'm trying to get a Dynamic Hyperlink added to sheet based on UserForm Textbox 6 The hyperlink links to FEDEX Tracking. is it possible to fix the below code to work.
VBA Code:
.Hyperlinks.Add Anchor:=.Cells(rg.Row, "H"), Address:="https://www.fedex.com/fedextrack/?trknbr=" & TextBox6 & "&trkqual=2459615000~" & TextBox6 & "~FX", TextToDisplay:=TextBox6
Textbox6 will be the Tracking number this will make the Link to FedEx tracking directly to FedEx.
Any help is greatly appreciated