ExcelBanter - block event

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - block event (https://www.excelbanter.com/excel-programming/320488-block-event.html)

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)

"Roman Töngi" wrote in message
...
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