RE: $$Excel-Macros$$ Search an fill combobox

2012-03-08 Thread Asa Rossoff
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

Re: $$Excel-Macros$$ Search an fill combobox

2012-03-07 Thread Sam Mathai Chacko
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

$$Excel-Macros$$ Search an fill combobox

2012-03-07 Thread Joaowild
Hi. Someone help with this: I have a book with aprox 20 sheets, many products are included. Well i need a search a defined product from combobox inside a userform, but when i write the first letter the macro run and don't let me write the others. I tried to put a delay but doesn't work. If you can