Run a macro from cell select

F

famdamly

What's the secret to doing this I can't find nothing on it?

I need to execute a macro that will involve using data from the row
that is selected. I don't want to write 50 macros with 50 buttons. It
seems there would be a way of having a macro assigned to a cell in row
1. Then copy and paste it all the way down the column.

The other way would be to have the user make a selection, basically
highlighting the data, then pressing a button to execute a macro. The
problem for me is, I don't know how the macro will know which row,
column or cell is selected.

Please help. I'm stuck.
 
L

L. Howard Kittle

Perhaps something like this, expanded to suit:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then RC1
If Target.Row = 2 And Target.Column = 1 Then RC2
End Sub

Sub RC1()
MsgBox "Run macro for row 1"
End Sub

Sub RC2()
MsgBox "Run macro for row 2"
End Sub

HTH
Regards,
Howard
 
F

famdamly

That's great Howard.

The only problem is I don't know how to reference the activated cell or
row # to have the macro know what row# so it could use that # to gather
other related data.
 
L

L. Howard Kittle

"activecell.row" will give you the row number. I must not have a full grip
on what you want to do.

If you want, send me a sample workbook and some detail of what you are after
and I will give it a go.

[email protected]

Regards,
Howard
 
Top