VBA - Left Shift to be Activated when Sheet is selected.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can Vba workout if a selection is part of a group? 0
Excel VBA help: Text file formatting 19
insert worksheet shift 11 tab 2
sheet event wait for another event? 6
Responding to Keypress event on a sheet 1
Locking and Unlocking Cells via VBA 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel crashes and restarts when accessing newly created worksheet 2

Back
Top