ComboBox DropDown when Key is pressed

  • Thread starter Thread starter shrekut
  • Start date Start date
S

shrekut

I am using the OnKey event to trap for the F6 key being pressed. The
ComboBox1.DropDown method is called in a macro when the user presses
the F6 key. Also on the same sheet as the combobox I have code in the
Worksheet's SelectionChange event that repositions the same combobox in
the ActiveCell. So the combobox follows the activecell.
The problem I am having is that when the user presses F6 and then
clicks on another cell the list stays open in the previous cell. Esc
does nothing for this.
Any suggestions?

Thanks...
 
Try using the combo box's lostfocus event to assist in
ensuring it is tidied up. I haven't thought about what
you might do, but this event should trap your problem for
you.

Steve
 
Thanks Steve.
I was able to solve my problem by using ComboBox1.Activate before I
used ComboBox1.DropDown. That one has been bugging me long enough.
 
Back
Top