Hi!

I'm not sure this is even possible since the insert hyperlink is disabled in an activex box but hopefully someone knows a way around this (through a userform or input box of some kind maybe?). I realize it may just be the text of the hyperlink, that would be fine.

Here's what I'm trying to do:

1. user clicks a label, gets the prompt to insert hyperlink
2. user selects the path as normal
3. user click "OK" and the hyperlink (or text of it) gets inserted into specified textbox

Can anyone help me with this?

Thank you!