ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   combobox change event triggered without change (https://www.excelbanter.com/excel-programming/388957-combobox-change-event-triggered-without-change.html)

Jacob

combobox change event triggered without change
 
I have a userform with a combobox. I have a change event so when the
combobox is changed a module is run. on the same userform I have a
save button to perform a "save as" for the file. when i click the
save button, the combobox change event is triggered which is causing
me problems. is there a way to temporary disable the change event
while the save is being performed? or is there another option to use
besides "change," that will not trigger in this case? thanks.



All times are GMT +1. The time now is 02:58 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com