Thread: MsgBox
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grey Newt Grey Newt is offline
external usenet poster
 
Posts: 16
Default MsgBox

Try something like this....

Sub Display_Message(
Dim UserResp As VbMsgBoxResul
UserResp = MsgBox("Hi - please click a button", vbOKCancel, "Hi"
If UserResp = vbOK The
MsgBox ("You clicked OK"
ElseIf UserResp = vbCancel The
MsgBox ("You clicked Cancel"
End I
End Sub