VBA Excel tabbing to/from controls

[dprayner]

Hi people. I have tons of controls (ListBoxes, textboxes, ComboBoxes, CheckBoxes, etc.) on my spreadsheet tabs. I was wondering how everyone typically handles tabbing to and from controls. I originally thought that if a certain cell is existed, one could SetFocus on the control. Unfortunately I don't know of any procedures for individual cells as there are for controls. It is kind of a pain for a user to have to click on controls when the could tab through the whole spreadsheet uninhibated. Any suggestions? DAVE

 

[taupirho]

How about trapping the keydown event for the control. If its keycode = 9 i.e TAB key then jump to the next control.

 

[dprayner]

Hi Taupirho. I tried this and it doesn't seem to work. I can't beleive how different controls are on UserForms and Spreadsheet. There is no SetFocus and the closest I have come is TextBox1.Select which doesn't work well. DAVE