Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
messagebox macro
i have the following macro running off a button to call a messagebox before a
macro is run; Sub Reconcile_Button() 'button to run "reconcile" macro, first runs dialogue box with YES/NO to confirm YESNO = MsgBox("Reconcile " & Range("F4").Value & " ?") Select Case YESNO Case vbYes Call reconcile Case vbNo End Select End Sub the problem is its not calling theb macro? i have tried this without the "call" before the macro name but still no luck!! the wierd thing is i have this macro on another sheet calling a different macro and it works? any help would be much appreciated |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
messagebox macro
try changing this:
YESNO = MsgBox("Reconcile " & Range("F4").Value & " ?") to this: YESNO = MsgBox("Reconcile " & Range("F4").Value & " ?", vbYesNo) -- JB "Patrick Bateman" wrote: i have the following macro running off a button to call a messagebox before a macro is run; Sub Reconcile_Button() 'button to run "reconcile" macro, first runs dialogue box with YES/NO to confirm YESNO = MsgBox("Reconcile " & Range("F4").Value & " ?") Select Case YESNO Case vbYes Call reconcile Case vbNo End Select End Sub the problem is its not calling theb macro? i have tried this without the "call" before the macro name but still no luck!! the wierd thing is i have this macro on another sheet calling a different macro and it works? any help would be much appreciated |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
To show a messagebox | Excel Discussion (Misc queries) | |||
MessageBox with tick box | Excel Discussion (Misc queries) | |||
messagebox help | Excel Programming | |||
messagebox help | Excel Programming | |||
Working around a messagebox | Excel Programming |