Solved: Disable One Procedure While Another Runs Then Enable Again

[f2e4]

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

[Bob Phillips]

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.

[f2e4]

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.

[Bob Phillips]

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]

[f2e4]

Hey,

That works perfectly

Thanks again,

F