View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default msg box within a macro

Post your macro

"Karine" wrote in message
...
Hello,

I have a macro and am trying to link a msg box to it. The msg box I have
is,

Sub Message_box()

Msg = "If this is the correct date selected click Yes to continue."
Title = "CORRECT DATE SELECTED"
Response = MsgBox(Msg, vbYesNo + vbQuestion, Title)


If Response = vbNo Then
MsgBox = "You Clicked NO. Please selected correct date"
Exit Sub 'Quit the Macro"
End If

MsgBox = "Your Data has been updated"
End Sub

I am trying to put that msg box with my macro but when i click my macro no
msg box pops up, I'm not clear how i should link the msg box with the
macro.
Any Help would be greatly appreciated.

Thanks,
Karine