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?

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)

"choice" wrote in message
...
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?

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

On 4/21/04 16:01, in article
, "choice"
wrote:

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?