ComboBoxes in Visual Basic, VB6, or VBA
These events are a bit confusing, because they might not operate in the way that you think they do. If you want to do something based on the user changing their selection in the combo box, then it is the Click event that you want to modify.
The default Style Property of a ComboBox is
0 - Dropdown Combo
Usually, this isn't what you want, because it allows the user to edit the text in the box. In order to force the user to select only the entries that exist in the combo box, set the Style Property to
2 - Dropdown List
Contact me: mcturra2000 yahoo co uk
Author: Mark Carter
Created: 11-Oct-2004
Keywords: Visual Basic 6, VB6, VBA
http://www.markcarter.me.uk/computing/vba/combobox.html
mcref01x