View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default running a VBA sub from a hyperlink

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

It has a nice example.



Paul James wrote:

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

"Tom Ogilvy" wrote in message
...
Use the follow hyperlink event to run the code.

--
Regards,
Tom Ogilvy

"Paul James" wrote in message
...
Is there any way to get a hyperlink to run a VBA sub procedure when you
click on the hyperlink?

Thanks in advance.

Paul





--

Dave Peterson