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

Hi Vishu,

Whether to use msgbox's between macros is up to you, it depends on what
you are trying to do and what reasons you may need to stop the macros
for.

To link them do the following:

Before the End Sub in Macro1 put the following:

If Msgbox("Would you like Macro2 to now run?", VBYesNo,"Macro2") =
VbYes then
Call Macro2
Endif

You will need to replace Macro2 with what ever you have called it etc.
You can put the same at the bottom of Macro2 changing the name of
Macro2 to Macro3 etc.

Regards,

James

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

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

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