running a VBA sub from a hyperlink

[Paul James]

Is there any way to get a hyperlink to run a VBA sub procedure when you
click on the hyperlink?

Thanks in advance.

Paul

 

[Tom Ogilvy]

Use the follow hyperlink event to run the code.

 

[Paul James]

Thanks for the info, Tom.

Question: could you please say a few words about how to use a follow
hyperlink event?

I know how to create a Sub Procedure in the VBE, and I know how to assign
the procedure to a command button. But how do you "follow" a "hyperlink
event?"

Thanks again in advance.

Paul

 

[Dave Peterson]

Take a look at FollowHyperlink Method in VBA's help.

It has a nice example.

 

[Tom Ogilvy]

The followhyperlink method is availabel in xl2000 and later.

right click on the sheet tab and select view code
At the top of the module,
in the left dropdown, select WorkSheet
In the righ dropdown select followhyperlink

Private Sub FollowHyperLink(byVal Target as hyperlink)

if hyperlink.Address = "yourhyperlinkaddress" then
call MyMacro
End if
End Sub

 

[Paul James]

Thank you, gentlemen. That's just what I needed.

 

[Tom Ogilvy]

That should have said,
The followhyperlink Event is available in xl2000 and later.

sorry about that.