Return an active hyperlink into a userform?

[matrixpom]

Hi all,

I have a short code attached to a command button on a Userform ("Userform1") that locates a specific row of information based on a cell value (Sheet1, column B), copies this info to another page ("Info"), then this Row of information is used to populate back into my Userform, the problem I'm having is one piece of information is a Hyperlink, this link address is lost as soon as it copies the row to Sheet "Info". Is there a way to adapt the code below to retain the Hyperlink address when it is transfered to Sheet "Info" & then enter an "active" hyperlink back into the Userform? Ideally the user would be able to click in TextBox 4 on the Userform & be sent to the coresponding link address? - As always thanks for any assistance guys - Marco

Please Login or Register  to view this content.

[Kenneth Hobson]

A button might be the better choice or button to follow the hyperlink address in textbox4.

This shows the concept.
1. Do a Copy/Paste, not copy, paste values only.
2. Use followhyerlink.

Please Login or Register  to view this content.