if macro
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?
|
if macro
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? |
if macro
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? |
All times are GMT +1. The time now is 03:58 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com