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?