Thread: ComboBox Focus
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default ComboBox Focus

hi
where do you want it to go once the tab key is pressed?
the escape key works .....ok. takes you to the last cell selected before
entering the combo box.
you could add some code to make it go were you want after the selection is
made.
Private Sub ComboBox1_Change()
Range("A1").Select 'or where ever
End Sub

code would eliminate the need to press a key after the selection.
my thoughts
regards
FSt1



"MikeF" wrote:

Am using an ActiveX ComboBox, presently with no VBA code.

It "word searches" just fine, but then doesn't "do" anything once the choice
is made, ie retains its focus.
Hitting tab or enter does not return focus to Excel, the user has to
physically grab the mouse and click in a cell.

Hitting the tab key to return focus to Excel would be ideal.

Any ideas?

Regards,
- Mike