Click event on combobox in a loop

  • Thread starter Thread starter smace
  • Start date Start date
S

smace

I have created a procedure that populates a listbox ( it works ok).
have tried calling it from a click event on a combobox, it seems t
loop, it works but takes a while to populate the listbox. Debugging th
code it looks like the click event is called multiple times. Trie
calling the same procedure from the change event on the combobo
instead but then I get a stack error!

The listbox and combobox are controls embedded into a worksheet.

Any ideas why this 'looping' should occur
 
Smace,

Post your code so that people may view it and give you the appropriat
help......there are plenty of very clever people on here but bein
psychic isn't one of their talents!

Simon
:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

inconsistent dir() behavior 1
Listbox populated based on Combobox 2
Unable to pass a control to a sub 1
UserForm Combobox Change Event 4
call a combobox KeyDown event from another procedure 2
Firing Event in another user form 1
Multi column listbox from combobox values 3
Can Listfillrange be used with a listbox or combobox on a form? 2

Back
Top