Hi,

I have some simple macro's who I want to start with a click on a command button. When I click on the button he has to run macro1, and when I click again on the same button he has to run macro2 and so on.

Is it possible to run more then one macro after a click on the same button?

When I use my code he runs both maco's after clicking on the button

Sub macro1()
Dim Get_Value As Variant
Range("A1").Select
Range("A1").Value = Range("E1").Value
End Sub
Sub macro2()
Dim setValue_Var As Range
Range("A2").Select
Range("A2").Value = Range("E2").Value
End Sub
Sub CommandButton1_Click()
Call macro1
Call macro2
End Sub

Thanks,
Costertje