Message box problem - code (1 Viewer)

[Walter]

Hi I have a message box that pops up on a event. the thing is i cant get it to dislpy right. i want it to display the exclamation box, with only the cancel option or if thats not possible the cacel/retry option
this is what i have for codeL:

msgbox("Prompt,vbexclamation,"Title",
now I've tried everything that I can think of but cant finish off the code correctly if you could help it would be greatly appreciated thanks,
Walter

 

[Walter]

Sorry posted in wrong section. My fault

 

[R. Hicks]

You coding needs a liitle work. In the event you are working with add this code:

Dim strMsg As String
Dim strTitle As String
Dim intResponse as Integer
strMsg = "Your message here"
strTitle = "Your message box caption here"
intResponse = MsgBox (strMsg, vbExclamation + vbRetryCancel, strTitle)
If intResponse = vbCancel Then
"Code to do something if Cancel selected"
Else 'retry was selected
"Code to do something if Retry selected"
End If

HTH
RDH

[This message has been edited by R. Hicks (edited 01-28-2000).]