Hyperlink to open a common dialog on a msgbox

H

Harinath

Hi All

How do i achieve to create a hyperlink on a message box display
if the user selects that hyperlink a common dialog should appear to display folder path

ex: something lik

Msgbox .....Hyperlink..

please put dome light on thi

Thank
Harinath
 
J

Jake Marx

Hi Harinath,

You can't do this on a MessageBox. You would have to create a UserForm that
looks like a MessageBox, add a Label control, change the font color and add
underline to make it look like a hyperlink, then use the Label's Click event
to show the common dialog you desire(Application.GetOpenFilename or
Application.GetSaveAsFilename may do what you're looking for).

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]
 
Top