not run macro on first instance

[MervB]

Word 2003 or XP - I have a tickbox in a userform which has a multi action
macro that runs on entry. Being the first userform control it automatically
fires when the form is openned. It is important that this be the first
control in the Tab sequence - how can I stop this macro from running on the
first instance?

Thanks
MervB

 

[Tony Jollans]

You could set a flag in Userform Initialize and then check it in your
checkbox entry ...

Dim FirstTimeFlag As Boolean

Private Sub UserForm_Initialize()
FirstTimeFlag = True
End Sub

Private Sub CheckBox1_Enter()
If FirstTimeFlag Then
FirstTimeFlag = False
Exit Sub
End If

' rest of your code

End Sub

 

[MervB]

Thanks Tony - sometimes the obvious kicks you in yhr eye and you still can't
see it!

I believe your spot on thanks again.

MervB