LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,718
Default Trigger Code with Mouse Click

I think it's going to be tough to figure out how a range was selected. I
might be inclined to have users double-click a cell, and then use the
Worksheet_BeforeDoubleClick event.

Btw, it might be more efficient to make your array a public variable and
populate it just once, say during the Workbook_Open event, rather than every
time a cell is selected.

--
Jim Rech
Excel MVP


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trigger or code Curt Excel Discussion (Misc queries) 0 April 20th 07 03:32 PM
Trigger code if certian data is present Jim G Excel Discussion (Misc queries) 2 April 20th 07 09:46 AM
Each Click of the Mouse D.Parker Excel Discussion (Misc queries) 13 April 28th 05 11:24 PM
Trigger code Bourbon[_21_] Excel Programming 5 January 26th 04 04:06 PM
How to code a timer to trigger a sub-routine ? Joseph[_10_] Excel Programming 1 December 18th 03 12:48 PM


All times are GMT +1. The time now is 10:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"