One Command button for 2 macros( Not in the same time)

[abjac]

Hi Is it possible to make one commandbutton run 2 different macros? I dont want them to run in the same time. When i press the button it shall run macro 1 (macro 2 is blocked), When that is finish the same button shall be able to run macro 2, and block for macro 1.
If any one have a simple code or and example it would be nice. Using excel 2003
Forgot to say it will be nice if the text on the button also can change, depend of which macro its ready for.

Sincerly
Abjac

[Norie]

You can use the text on the button to decide which code to run.

Private Sub CommandButton1_Click()
     
       Select Case CommandButton1.Caption
            
            Case "Run Macro1"
                  Call Macro1
                  CommandButton1.Caption = "Run Macro2"
            Case "Run Macro2"
                  Call Macro2
                  CommandButton1.Caption = "Run Macro1"

      End Select

End Sub

[RHCPgergo]

Hi,

try something like this (you need to assign Sub WhichMacro to the button):

Option Explicit
Dim MacroOne As Boolean

Sub WhichMacro()
If MacroOne = True Then
    Call Macro1
Else
    Call Macro2
End If
End Sub

Sub Macro1()
MsgBox "macro1"
MacroOne = False
End Sub

Sub Macro2()
MsgBox "macro2"
MacroOne = True
End Sub

[abjac]

Hi Norie and RHCPgergo abd thank for you answer. Nories your solution is exactly what i want and its working really good. Specially i like that it change the text.
RHCPgergo your is also really good, for me i just want the text changed. But great also.

Thanks to both will mark this as solved.

Have a nice day

Sincerely
Abjac