Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a VBA sub from a hyperlink
Is there any way to get a hyperlink to run a VBA sub procedure when you
click on the hyperlink? Thanks in advance. Paul |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a VBA sub from a hyperlink
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a VBA sub from a hyperlink
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a VBA sub from a hyperlink
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 wrote in message ... 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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Thanks to Dave and Tom
Thank you, gentlemen. That's just what I needed.
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
running a VBA sub from a hyperlink
That should have said,
The followhyperlink Event is available in xl2000 and later. sorry about that. -- Regards, Tom Ogilvy Tom Ogilvy wrote in message ... 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 wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Paste Hyperlink result as working hyperlink | Excel Worksheet Functions | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |