Run a macro from cell select
 

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.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=518403

Run a macro from cell select
 

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

"famdamly" wrote in
message ...

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.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=518403

Run a macro from cell select
 

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.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile: http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=518403

Run a macro from cell select
 

"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.



Regards,
Howard

"famdamly" wrote in
message ...

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.


--
famdamly
------------------------------------------------------------------------
famdamly's Profile:
http://www.excelforum.com/member.php...o&userid=29382
View this thread: http://www.excelforum.com/showthread...hreadid=518403