enter data in combo box without clicking on box

[lbenner]

Hi: On my worksheet (Excel 2007), the user will be entering data in both cells and combo boxes. Each time he enters info in a cell, he hits enter and the cursor moves to the next cell; however, if there is a combo box positioned over a cell, I would like the cursor to move into the combo box in order for the user to enter at least the first letter without picking up the mouse and clicking.

I am assuming I need a change event on the previous cell, but I can't figure out what code to use. I tried setfocus, but that didn't work.

 

[cstimart]

If I understand right, you would need to setfocus on the combobox when it is loaded...not on the previous cell.

 

[lbenner]

I tried to setfocus after the value in the previous cell changed, but this did not work. When I typed (without clicking first) the letter I typed went into the cell under the combo box. I read on a forum somewhere that you can't set focus on a combo box in a worksheet--not sure if this is true.

I'm sorry, I'm not sure what you mean by "when it is loaded."