View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jake Marx[_3_] Jake Marx[_3_] is offline
external usenet poster
 
Posts: 860
Default 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