Combobox to cell navigation

S

suzanne

Is this possible?
I have designed several combo boxes into a spreadsheet
where info is also entered into unprogrammed cells. I
would like to be able to navigate from a combo box to a
cell without using the mouse. (Tab does not work at all.)
Any program/setting information regarding this would be
great!

Thanks,
Suzanne
 
B

BrianB

This is because the combobox retains the "focus" (remains selected) and
can give rise to all sorts of problems.

When using worksheet controls/textboxes etc. I usually include
something like :-

ActiveSheet.Range("A1").Select

in my code which ensures that focus is returned to the worksheet and
things work as normal.
 
Top