ComboBoxes and Tab Stops

  • Thread starter Thread starter tcross
  • Start date Start date
T

tcross

I am creating a form for use by others. In a protected worksheet i
which you can only tab through and select unprotected cells, how can
make a ComboBox and/or ListBox a tab stop? For example: After enterin
an applicants name I need them to select a specific job title from
list. Right now the only way the user would be able to do this is wit
the use of the mouse and since the end users use lap tops it would b
much more user friendly if they could tab to the list as they do to th
next cell needing input.
I am working in Excel 2000. Any assistance would be greatl
appreciated. I have been stumped on this way too long
 
You could use data validation for the cell with the drop
down instead of combo or list box. Then when they tab to
the cell, Alt+down arrow will show the list, and the
down/up arrows will let them move thru the list.
HTH. Peg
 
All these years and I did not know about validation. Awesome! thanks fo
such a simple fix
 
Back
Top