Add a combo box

[bobsuds]

I created a combo box with values from another sheet. The box and dropdown
work great. Is there a way to tab from a cell into the combo box as well as
one combo box to another. When I tab now the curser goes into the cell
behind the combo box. I am using Excel 2003.

 

[JLatham]

I believe that this would take some VB code (macros) that would likely
require some complex logic to work exactly the way you want. Unless you had
some very strict rules to govern when to do a "special" tab action, it could
get pretty squirrely in the code.

For instance, how do you (the code) know whether the user wants to tab from
combo box #1 to combo box #2 or actually wants to do a normal tab out of the
combo box to a cell on the worksheet?

You might give consideration to locking cells you don't want to be entered
when a [tab] is used and then protecting the sheet with the option to allow
selecting locked cells cleared.