Help with Hyperlink to track UPS shipments

[Wombat]

I have a continuous form with a list of active shipments including the tracking number. Is there a way that I could make the textbox containing the tracking number into a hyperlink that brings me to the UPS website and tracks the shipment?

I searched and didn't find anything very useful, I'm a little surprised that this isn't a common question.

[Wombat]

Here is the link to track a package:

http://wwwapps.ups.com/WebTracking/p...racknums_displ ayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumb er1=<TRACKING NUMBER HERE>&track.x=0&track.y=0

I guess with that info, I can use the onClick event of the textbox to trigger vba that constructs the link with the tracking # in it and then... somehow goes to it.

[pbaldy]

Check out FollowHyperlink in VBA help. As you say, build a string that includes the fixed text and the tracking number.

[Wombat]

Thanks for the help. Maybe the reason this isn't asked more is because it's actually quite easy.

Here is my code, in case any future users need.

Private Sub txttracking_Click()
Dim link As String
Dim track As String
track = txttracking.Value
link = "http://wwwapps.ups.com/etracking/tra...InquiryNumber1=" & track
Application.FollowHyperlink link, , True
End Sub

[pbaldy]

Happy to help.