Hi all-

I tried searching through the forum but couldn't find answer:

I want to add a command button to a form where if a user clicks it a
file browse window comes up (like for opening a file) and if a user
navigates through and selects a file I assign the path to this file as
a hyperlink to an entry in a spreadsheet - so that a future user can
open this file just by clicking on the link.

I learned how to assign hyperlink by doing a macro record, but do not
know how to incorporate file browse function. any help would be much
appreciated.


--
b-123
------------------------------------------------------------------------
b-123's Profile: http://www.excelforum.com/member.php...o&userid=26649
View this thread: http://www.excelforum.com/showthread...hreadid=399227