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