Thread: msgBox
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
RB Smissaert RB Smissaert is offline
external usenet poster
 
Posts: 2,452
Default msgBox

I think you want something like this:

If MsgBox("Do you want to abort this macro?", _
vbYesNo + vbDefaultButton2 + vbQuestion, _
"aborting macro") = vbYes Then
Exit Sub
End If

RBS

"april27" wrote in message
...
I have a problem with my help menue so please dont just refer to it. i want
to have a messagebox that pops up when the user presses a button. the
message
box shall ask the user if he(she is sure if he wants to abort. i just dont
get the syntax. I know to write the text on the box but how to choose how
many and what type of buttons etc. i dont know. i dont know how to connect
an
event to certain button in the message box. please help me on this one!!!!