Put this in the code module for the worksheet (not a general module where
macros 1-3 are)

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Not Application.Intersect(Range("A:A"), Target) Is Nothing Then
macro1
macro2
macro3
Else
Exit Sub
End If
End Sub

This should detect when any cell is selected in column A and run the macros
in succession.

Mike F
"GatheringShadow" wrote in
message ...

This is a question that may or may not have been addressed, but I've
been looking for answers for a while and can't find any. Frankly, it's
driving me crazy. So, here's the question.
I created separate macros to initialize values for three cells in
Excel. The reason I did this is because they each refer to cells in
relation to themselves, so one macro won't work. Now I am trying to
select a row (or the first cell in the row) to have one macro activate
all three. However, the macro only references the row I recorded the
macro on, not any other row I may select. I've tried four or five
different ways to edit the macro (both after recording it or simply
starting cold). Nothing seems to work. Can anyone help me to
reference cells in a macro, based on the starting row or cell?

ex. Row 12 is selected. A12 should execute Macro1, B12 Macro2, and
C12 Macro3
OR
Cell A5 is selected. A5 is Macro1, B5 Macro2, and C5 Macro3

Either way is fine with me, either selecting the first of three cells
or the entire row. Thanks for any help you can give me.

New excel, old programmer....


--
GatheringShadow
------------------------------------------------------------------------
GatheringShadow's Profile:
http://www.excelforum.com/member.php...o&userid=15529
View this thread: http://www.excelforum.com/showthread...hreadid=270964