Simple VBA reference help

[percy83]

Hi all,

I have the following code:

Option Explicit

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
If Target.Address <> "$G$25" Then Exit Sub
Splash.Show

End Sub

This code triggers a userform to show. My problem is that I want to change the absolute reference $G$25 to my named range "About". I have tried a few different things but can't get it working correctly.

Thanks in advance!

BR
Percy

 

[circledchicken]

Hi,

Try replacing "$G$25" with Range("About").Address

 

[Magriza]

You could try:

If Not Intersect(Range("About"), Target) Is Nothing Then
    splash.Show
End If

 

[percy83]

Thanks so much!

Works like a charm.