View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bearly_competent[_2_] bearly_competent[_2_] is offline
external usenet poster
 
Posts: 5
Default cell update doesn't run macro

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