View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Karine Karine is offline
external usenet poster
 
Posts: 20
Default msg box within a macro

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