Stop Combo Box Sub Running

[eoinymc]

Hi,

I have a large macro called SplitData, which takes a load of data and splits it and reformats it each month.

I have 4 Activex Control combo boxes on one sheet that are linked to a range...this range changes each month, so I blank out the range and then repopulate.

My problem is that when I blank out the range, it triggers the Private Sub ComboBox1_Change() and throws some errors because there is no data to select.

So, I was wondering if there is something I can set in my SpltData macro that will not run the ComboBox1_Change sub while the SplitData macro is running?

Any help would be greatly appreciated!

Thanks,

Eoin

 

[BrianB]

It is possible to stop events occurring while code is running and then re-enable them something like this. Please note that if you code does not finish events will be switched off.
It is only possible to re-enable with code.

Application.EnableEvents = False
'=================================
'- your code here
'=================================
Application.EnableEvents = True