Private Sub Worksheet_SelectionChange(ByVal Target As Range)

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

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)


"Arturo" <Arturo@discussions.microsoft.com> wrote in message
news:3D49C53F-9243-4FCD-BFB9-DC7181B4420C@microsoft.com...
> 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

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.

--
Regards,
Tom Ogilvy


"Arturo" <Arturo@discussions.microsoft.com> wrote in message
news:3D49C53F-9243-4FCD-BFB9-DC7181B4420C@microsoft.com...
> 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