View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
[email protected] hans.van.snick@home.nl is offline
external usenet poster
 
Posts: 3
Default 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