Marco Help
 

Hello
I have a text box with an assigned macro. I want th run two macros off of
the button. Which macro runs will depend on the location of the active cell.
User will have two options. If cell A1 active, button will run macro a. If
cell B1 active, button will run macro b.

Tank you

Marco Help
 

assign ur button to macro "Butt"

Sub Butt()
If ActiveCell.Address = "$A$1" Then Call a
If ActiveCell.Address = "$B$1" Then Call b
End Sub

Sub a()
MsgBox ("") & ActiveCell.Address
End Sub

Sub b()
MsgBox ("") & ActiveCell.Address
End Sub


"looper" skrev:

Hello
I have a text box with an assigned macro. I want th run two macros off of
the button. Which macro runs will depend on the location of the active cell.
User will have two options. If cell A1 active, button will run macro a. If
cell B1 active, button will run macro b.

Tank you

Marco Help
 

Would suggest instead using an Event Macro, specifically a
double-click macro, and test the target address, column, or row.
http://www.mvps.org/dmcritchie/excel/event.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"looper" wrote in message ...
Hello
I have a text box with an assigned macro. I want th run two macros off of
the button. Which macro runs will depend on the location of the active cell.
User will have two options. If cell A1 active, button will run macro a. If
cell B1 active, button will run macro b.

Tank you