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

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