block event

  • Thread starter Thread starter Roman Töngi
  • Start date Start date
R

Roman Töngi

would like to block the "ComboBox1-change"-event until
the code in "Workbook_load" has processed completely.
one sulution could be to set a variable in a module, which
is observed by "ComboBox1-change" at the beginning.
if that variable is 0 then abort otherwise continue.
At the end of "Workbook_load" that variable is set to 1.
Does anyone know a better solution.

Thank
Roman
 
Roman,

What is the problem with that solution?


--

HTH

RP
(remove nothere from the email address if mailing direct)
 
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

list box remove item by combobox 4
cancel a combobox change 1
run time error 424 object required - how to load control on Userfo 4
ComboBox Problem with ListIndex 2
Can you create a global variable ? 11
Run time 9 error for some users but not everyone 10
Load a ComboBox without triggering another event 2
still get runtime error 424 9

Back
Top