LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 15
Default Is there a VBA Event to Detect Change in ActiveCell Focus?

I have an Excel worksheet that functions as a form of "X"ed items --
operating much the same as check boxes, but without using actual check box
controls. I would like to set an event that would trigger on clicking any
cell within a "watched" range -- which would then check to see what cell is
now active, and toggle "X" values on or off depending on what it finds in
the selected cell. Any thoughts??

Thanks in advance!! Larry.


 
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
What event to detect click on UserForm ListBox? Don Wiss Excel Programming 1 August 26th 05 10:35 PM
how to detect mouse pressed(down) event for work sheet helpwithXL Excel Programming 0 February 18th 05 03:05 PM
Detect event if excel is in edit mode. Rajeev Excel Programming 2 February 7th 04 02:22 PM
event which occurs when a TextBox receives focus Mikhail Excel Programming 2 October 7th 03 02:27 PM
How to detect an entire column/row delete event? MV[_2_] Excel Programming 1 September 10th 03 01:03 PM


All times are GMT +1. The time now is 04:42 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"