Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
need help to update macro to office 2007 macro enabled workbook | Excel Discussion (Misc queries) | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |