Because he is not using the address string, but the Range("B15")

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Dkline" wrote in message
...
Thanks for your help. It's interesting that your solution worked without
an
absolute reference.

"Mark Ivey" wrote:

See if this will work for you...


Private Sub Worksheet_Change(ByVal Target As Range)
Dim myList As String
If Intersect(Target, Range("B15")) Is Nothing Then
Else
myList = Target.Value
MsgBox "B15 Changed"
End If
End Sub


--
Mark Ivey


"Dkline" wrote:

In a worksheet named "GUI" I have a drop-down in cell "B15". What I
need to
do is as the end user makes a selection change in this drop-down, it
runs a
macro to recalculate.

I am using the code below in the "GUI" worksheet:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "B15" Then
Call SideFundSolve
End If
End Sub

The behavior I'm getting as I watch it in the debugger is it just skips
over
the Call. What am I doing wrong?