Attaching Macro to Cell instead of button?
On 29 aug, 22:36, Satchmo2006
wrote:
Hello,
I have a cell that is a list. Instead of attaching a Macro to a button, I
would like it to run everytime a new selection from this list is selected. Is
this possible? If so, how?
Much thanks!
You mean something like this ??
example macro xx reacts to changes on sheet 1
Sub xx()
Range("c1").Value = Range("a1").Value * Range("b1").Value
End Sub
groeten. Hans
(click on tab view code . in top line the following)
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
xx
End Sub
|