Hyperlink to open a common dialog on a msgbox
 

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

Hyperlink to open a common dialog on a msgbox
 

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]


Harinath wrote:
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 like

Msgbox .....Hyperlink...

please put dome light on this

Thanks
Harinath