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]
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]
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote