First off, thanks for taking the time to read this. I'm using Excel 2007, and I'm stumped on a userform
question (mostly because I'm not sure if it's possible).
I have a userform that has a textbox in which the excel
user should enter the file location; to facilitate this action, I set that textbox to show the "Insert Hyperlink" dialog box
Private Sub LocationTextBox_Enter()
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
I'm wondering if, and how, it's possible to show the Insert Hyperlink dialog box, then populate the LocationTextBox in
the userform with the hyperlink chosen in the Insert Hyperlink dialog box (i.e., after pressing "OK" on Insert Hyperlink
dialog box, LocationTextBox is populated with the file path as text).
I realize this seems a bit of overkill, as
people can just type in the file path, but if it's possible to pull off the above it would really help to make the overall
project easier to use for folks who are a bit Excel-unfriendly. Thanks in advance for any help.