ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Tab-key (https://www.excelbanter.com/excel-programming/296208-tab-key.html)

Kent Schederin

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

KS



Dave Peterson[_3_]

Tab-key
 
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

Kent Schederin wrote:

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

KS


--

Dave Peterson



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com