View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Juan Sanchez Juan Sanchez is offline
external usenet poster
 
Posts: 19
Default macro triggered by a change to a cell


In XX sheet's view code...

Private Sub Worksheet_Change(ByVal Target As Range)
Dim rng As Range
Set rng = [Q2]

If Intersect(Target, rng) Is Nothing Then Exit Sub

'write your code here

End Sub

Cheers
Juan






-----Original Message-----
I want a macro ("WWW") to run wheneven I change the
selection in a combobox (located in sheet "XX"
Cell "Q2")? How do I write "WWW"? thanks much.
.