sorry about the extraneous £

--
HTH

Bob Phillips

"vishu" wrote in message
...
Hi Bob..
Thank you for your great help.
regards
vishu

"Bob Phillips" wrote:

ans = MsgBox("Yes or No"£, vbYesNo"
If ans = vbYes Then
Call macro2
Else
Call macro3
End If

--
HTH

Bob Phillips

"vishu" wrote in message
...
I have doubt with macro coding.
I have three macros to run.
In first step: If user press a macro button it has to run the Macro1,
after
running this, there is one message box will popup asking for "Yes" or
"No"
Now question is If user select "Ok" it should run the macro2 and If
user
select "No" it should run the macro3.
Just I want to know how to link the Macro 2 and Macro3 after message
box
message button.
Should I use "Buttons" in between macros????????????????
I hope this make sense.
Regards,
Vishu