Tab-key

  • Thread starter Thread starter Kent Schederin
  • Start date Start date
K

Kent Schederin

How can i catch when the user press the Tab-key and moves from A1 to B1?

KS
 
I'm not sure if you can trap that.

But you could trap the change of selection using either of two events:
Worksheet_SelectionChange
Workbook_SheetSelectionChange

These are events that excel can monitor.

If you think you might want to use them, take a look at Chip Pearson's site:

http://www.cpearson.com/excel/events.htm
 
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

Excel Move or Copy Stopped Working? 0
How to delete previous data from 1 macro before running the next? 4
Where was I before pressing enter/return or tab key 1
Windows 10 Itunes/TabKey 0
Active.Paste Error 1
Clear value in cell when the "enter" key is pressed 10
textbox disappears using textbox.activate 3
Change the action of TAB Key 3

Back
Top