Tabbing through comboboxes in Excel 
Author Message
 Tabbing through comboboxes in Excel

Does anyone have any idea of how to tab through controls in an Excel

I've added a number of comboboxes to my Excel spreadsheet and am trying
to setup some type of tab order.  With Excel, though, you cannot use
the tabindex property (it doesn't exist) for comboboxes (only user
forms in Word).  I'm probably going to have to write some code
manually.  Also when I go into the VB code, the "tab order" option
under the VIEW menu is greyed out.

The combobox is laying on top of it's linked cell.  So when a user
tries to tab to the combobox, it just tabs to the next cell behind the

I've tried writing some VB code that says something to this effect:

"If targetcell=f15 then Combobox0 get.focus"

But that didn't work.  Any ideas where I can get code to do this?

Paul R. Mesker
System Engineer
Dirigo Inc.

Sent via http://www.*-*-*.com/
Share what you know. Learn what you don't.

Sun, 02 Dec 2001 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. how to use tabs in Comboboxes

2. inserting tabs into comboboxes

3. Tabs in ComboBoxes

4. Tabs in Comboboxes

5. Help Please!! comboboxes in Excel using ActX

6. Importing Excel SpreadSheet(w/TABS) into Access Table

7. Getting Tab separated data from Word to Access, Excel or simply process it from VB

8. Getting Tab separated data from Word to Access, Excel or process it from VB

9. Use VB to save Excel Spreadsheet as Tab Delimited File

10. MS EXCEL VBA - qualify tabbed number

11. Tab UI with scroll bars (like Excel)

12. Microsoft style icons & Excel style tabs


Powered by phpBB® Forum Software