Private Sub Worksheet_SelectionChange(ByVal Target As Range)

[Guest]

Cell F9 has a validation list associated with it.
Is there a way to specify Worksheet_SelectionChange firing only if cell F9
changes?
Am not readily finding detail on (ByVal Target As Range)
Thanks,
Arturo

 

[Bob Phillips]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Address = "$F$9" Then
With Target
'do your stuff
End With
End If
End Sub


--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = $F$9" then
' your code
End if
End Sub

Note this is the change event, not the selectionchange event.

http://www.cpearson.com/excel/events.htm

Chip Pearson's page on events.