Hyperlink text in textbox using command button

[ANARDIL1986]

Hello

I currently have a Userform as a form of data input on an excel spreadsheet. It is made of several textboxs that simply copy the data in the textboxes to the next empty row on the spreadsheet

It is possible for when one of these textboxes has text in it, to hyperlink that text to a predifined sheet. For example textbox1 is filled with "D12,D15,D25" when the command button is pressed on the userform to insert this data into the sheet is it possible to hyperlink this text to say 'Sheet5' so that the text hyperlinked when it is in its cell?

Regards

[LJMetzger]

Hi ANARDIL1986,

The following macros may help you:

Please Login or Register  to view this content.

Lewis