I an analyzing costs on a worksheet. I would like to do a backward
comparison using goal seek.
My input for goal seek is in range "Mygoal"
MyMacro runs fine when i run it from a button after putting my input value
in "Mygoal". code is.
Private Sub myMacro()
Dim myvalue As Integer
myvalue = Worksheets("Cost Sheet").Range("mygoal").Value
Range("MyBillingRate").GoalSeek Goal:=myvalue,
ChangingCell:=Range("MyAccountfactor")
End Sub
I would like to run Mymacro when I "enter" a value into range "Mygoal"
can I do so through the change event? I
--
Martin
Bookmarks