Help With Message Box

[BRANDON99]

Hi all

I am using a meesage box that appears if an If statement is True, I want the user to be able to continue running the code when they click the OK button. Can someone please supply the code for this

Many Thanks

Brandon

 

[kphu]

Brandon,

What happens if the user selects cancel?

 

[kphu]

Brandon,

The code would be something like this.

Sub messagebox()
Dim response As Variant
If "Your test" Then
response = msgbox("Your message", vbOKCancel)
If response = vbCancel Then
Exit Sub 'this will exit the code
Else
'this will allow it to continue running
End If
End If
End Sub

 

[BRANDON99]

Thanks Kphu

That seems to do what I want