if macro

[Guest]

cell a1 can have to possible values, 1 or 2. if a1=1, when i hit a button i want macro1 to go. if a1=2, when i hit the same button i want macro2 to go. is this possible?

 

[Bob Phillips]

Tie Macro1 to the button

Sub Macro1()
If Activesheet.Range("A1").Value =1 Then
Macro2
ElseIf Activesheet.Range("A1").Value = 2 Then
Macro3
End If
End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

cell a1 can have to possible values, 1 or 2. if a1=1, when i hit a button

i want macro1 to go. if a1=2, when i hit the same button i want macro2 to
go. is this possible?

 

[TH]

An easy way is to call the same macro and test for 1 or 2 in this cell and
continue execution accordingly.

If Range("A1") = 1 then
macro1
ElseIf Range("A1") = 2 then
macro2
Else
MsgBox "A1 must be 1 or 2"
End If

TH