X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Simulating A Cell Click Event In Excel    
post Jun 20 2011, 08:54 AM

Posts: 41
Joined: 12-May 11

Hi All
recently came across this little gem and thought others might be as interested in this as I was. The idea of a click event on a given cell is something that would have been very handy for several projects and this demo show just how easy it is to achieve.
Basically all you need to do is create a hyperlink on the relevant cell and instead of pointing the hyperlink to some external source, point it back at the cell itself (on the dialog). When the cell is clicked the Worksheet_FollowHyperlink event is fired, this event has a Target parameter which is an object representing the hyperlink and the Target.SubAddress property contains the sheet name and address of the cell that was clicked.
The demo is pretty much self explanatory but if you have any questions I'll be glad to help out.
All the best
Attached File(s)
Attached File  simulated_click_event_using_hyperlinks.zip ( 14.23K )Number of downloads: 29
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    6th August 2020 - 11:05 AM