Or use the AfterUpdate event.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sam Mathai Chacko
Sent: Wednesday, March 07, 2012 11:05 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Search an fill combobox
The ComboBox1_Change
The ComboBox1_Change event is designed to work that way. Stop using the
change event for this. Each time you type a letter, there is an event
triggered. If you do not want to search to be triggered, why don't you use
a button click for this. Type in the name in the combobox, and then click
the butt