Tab Order. How to???

**Ninjataktikz** · 09-12-2012, 01:40 PM

I have 2 drop down menus and a Button on my worksheet. How can I have it setup so I can tab through them instead of actually clicking on them.

Thanks.

**Leizure** · 09-12-2012, 03:27 PM

What happens when you use the tab key then?

**Jakobshavn** · 09-12-2012, 03:39 PM

If you have a drop-down in a cell, it does not matter if you select the cell by clicking on it, using the TAB key, using the ARROW keys, or using the ENTER key.
However you select the cell, the pull-down symbol will appear. Once the pull-down symbol appears, you still need the mouse to display the pull-down options (or use ALT-DOWNARROW)

**Ninjataktikz** · 09-12-2012, 03:50 PM

Originally Posted by Leizure

What happens when you use the tab key then?

Nothing Happens.

Originally Posted by Jakobshavn

If you have a drop-down in a cell, it does not matter if you select the cell by clicking on it, using the TAB key, using the ARROW keys, or using the ENTER key.
However you select the cell, the pull-down symbol will appear. Once the pull-down symbol appears, you still need the mouse to display the pull-down options (or use ALT-DOWNARROW)

Btw I think I shouldve added this earlier these 2 Drop downs and the button that I have are from the ActiveX Control but they are not in a Form there on a Worksheet.

When I press Tab or Enter or Arrow Keys it does nothing. I would like it so they can select combobox 1 and tab go to combobox 2 and just press Enter and Enter Button would default be clicked.

hope that explains little bit more. Thank you for your responses guys.

**watersev** · 09-12-2012, 04:59 PM

hi Ninjataktikz, please check attachment, hope that helps

To move between dropdowns and a button use TAB key
To enter value in a validation drodown use ALT+Up or Down arrows
To click the ActiveX button press CTRL+Enter