A hyperlink built from cell contents

[A_Pitts]

I want a macro to post a hyperlink showing the shipping status of an item. I want to be able to enter a date in cell F12 and have it be the "label" or displayed text for the link in E12. And I want to enter a UPS tracking number in G12 and concatenate it into the URL in E12 so that when a user clicks the cell, the hyperlink runs and displays the tracking info.

 

[Yogi Anand]

Hi A_Pitts:

How about concatenating the various entries and then using the HYPERLINK function as in ...

y031228h1.xls
	A	B	C	D
4
5	http://www.mrexcel.com/board2/	viewtopic.php?	t=72860
6
7	http://www.mrexcel.com/board2/viewtopic.php?t=72860
8
Sheet5

I know it is not directly answering your question -- but I thought it might help!

 

[A_Pitts]

Yogi,
Thanks for the help, but I want to display the date. When you insert a hyperlink manually, the option at the top of the input box is "text to display". I want to display the user supplied date which I gather in a cell, and have the concatenated URL existing beneath it. I have built hyperlinks with concatenation by hand, but never with a macro. The macro input box does not allow you to paste into it and I was hoping that VBA would allow me to get around this.

 

[tusharm]

There is no need for VBA.

The 2nd parameter in the HYPERLINK function is the 'friendly name.' Use something like =HYPERLINK(B14&"."&C14&"."&D14,TODAY()) Format the cell with the preferred date format (Format | Cells... | Number tab).

Yogi,
Thanks for the help, but I want to display the date. When you insert a hyperlink manually, the option at the top of the input box is "text to display". I want to display the user supplied date which I gather in a cell, and have the concatenated URL existing beneath it. I have built hyperlinks with concatenation by hand, but never with a macro. The macro input box does not allow you to paste into it and I was hoping that VBA would allow me to get around this.

 

[Yogi Anand]

Hi Tushar:

Thanks for keeping us in line -- why use a macro if none is needed!

 

[tusharm]

Well, your solution didn't use VBA either. But, for some reason the OP believes it to be necessary.

Hi Tushar:

Thanks for keeping us in line -- why use a macro if none is needed!