Hyperlinks & Userforms

[Michael Wise]

Did some forum searching and did not find anything that could help with my specifics so here is delima. I will first start with a question. Do hyperlinks work within forms. If so where can I find some info on this. What I wanting to do is I would like to be able to input a link to a "folder" via browse type selection. I then need to be able to return and open this folder at a later time. Thanks for any advice

Michael

[dominicb]

Good evening Michael Wise

I'm not entirely sure what you're after here. It is not possible to put a hyperlink on a userform, but you can "imitate" one to try and fool the user that it's a hyperlink, but reading the rest of your post I don't think that's what you want. You really need to design your form with a button that kicks off a routine that will allow the user to select a directory, and here you have two choices :
(i) using the FileDialog object (only available usign XL2002 onwards). The simplest option
(ii) using API's and callbacks, which I think look slicker but are quite tricky to work with.

Both methods are discussed here :
http://book.itzero.com/read/others/0...9lev1sec5.html

HTH

DominicB

[royUK]

There's an example workbook here:

http://www.excel-it.com/vba_examples.htm