Are events enabled.

Type

Application.EnableEvents = true

in the immediate window

--
---
HTH

Bob


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



"bearly_competent" wrote in
message ...
I've searched thru lots of posts, and I can't understand why only I seem
to
have an issue with starting a macro based on a cell change. This code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "B3" Then
Call volatility_rate
End If
End Sub
-doesn't do squat, whether I change the cell thru the drop-down or
manually.
Why not? I have this coded in the worksheet I want it for, and nothing
happens.

Thanks,
-Dave