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...


---
Message posted from http://www.ExcelForum.com/