How do i call a macro from a cell

  • Thread starter Thread starter KhanhNguyen
  • Start date Start date
K

KhanhNguyen

I have a problem
The "A3" cell 's formula contain "A1" and "A2"
I want to do this work " when the value of cell "A1" change, excel
automatically GoalSeek cell "A3" to the goal:=100 by changing cell "A2"
"
That mean the value of cell "A3" always is 100 whatever cell "A1" 's
value is
Please help me !
 
hI

Try using the worksheet change event to trigger the solver

Private Sub Worksheet_Change(ByVal Target As Range)
If Target = Range("A1") Then
... Record the solver macro and paste in here
End If
End Sub

Regards

ADG
 
Back
Top