Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Left Shift to be Activated when Sheet is selected.
VBA - Left Shift to be Activated when Sheet is selected.
I would like have the Left Shift to be Activated (Down) when a Perticular WorkSheet is selected. I would also like to know if it's possible to trap KeyDown Events or Mouse Click Events in a WorkSheet? Does anyone have any suggestions? thanks Brad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Left Shift to be Activated when Sheet is selected.
The SelectionChange event will capture selecting a cell. This would be
trigger regardless of the method of selection, but includes clicking the mouse on a cell. Other than that, there is no built in event to capture mouse events or keyboard event. You would probably need to subclass Excel to get this type of control Not sure what a Left Shift Activated would accomplish or how that would be done. It isn't a toggle like Shift Lock or Num Lock. -- Regards, Tom Ogilvy "BradWarr" wrote in message ... VBA - Left Shift to be Activated when Sheet is selected. I would like have the Left Shift to be Activated (Down) when a Perticular WorkSheet is selected. I would also like to know if it's possible to trap KeyDown Events or Mouse Click Events in a WorkSheet? Does anyone have any suggestions? thanks Brad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto-ID and Delete/left shift cells when a cell contains text? | Excel Discussion (Misc queries) | |||
When I hit shift + left click highlighted object stuck. | Excel Discussion (Misc queries) | |||
How can I shift my data line to the left? | Charts and Charting in Excel | |||
Delete a blank cell and shift left | Excel Programming | |||
Delete a blank cell and shift left | Excel Programming |