I have a listbox connected to a chart that depending on the value selected, will refresh the chart with a different series.
However, the code I use to calculate all the core data for the charts , keeps crashing only while the coed for the listbox is active.
Is there anyway to diactivate the listbox_change code while the caculation code is running, then once finished, enables the listbox code again.
Thanks
F
You need to create a public variable, and set that when the calculate macro starts and unset it at the end. Your listbox code then checks this variable, and exits quietly if set.
I think i'm having a real rain freeze at the minute.
Can anyone explain this, e.g. how to set and unset a public variable, and have it checked before running code.
standard code module
[vba]
Public RunList as Boolean
[/vba]
in the controlling code
[vba]
RunList = False
'working code
RunList = True
[/vba]
Listbox code
[vba]
If RunList Then
'do its stuff
End If
[/vba]
Hey,
That works perfectly
Thanks again,
F