Hyperlink to show a userform

[MJKelly]

Hi,

I use hyperlinks to navigate around a spreadsheet instead of command
buttons. But how can I get a hyperlink to show a userform or run a
macro? Is this possible? If so, how?

kind regards,
Matt

 

[Gary''s Student]

Don't know about userforms, but there are two ways to get a hyperlink to run
a macro:

1. Have the hyperlink jump to a certain cell in the worksheet and then have
a worksheet event macro detect the selection and run your code.

2. Use a Workbook_SheetFollowHyperlink macro you call your macro. This
works with hyperlinks implemented with Insert > Hyperlink and not the
hyperlink function.

 

[MJKelly]

Thanks for that. I suppose I could just use a userform.show in the
macro anyway.

Great,
Matt