How do i call a macro from a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

KhanhNguyen - 24 Jun 2006 10:24 GMT

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 !

Signature

KhanhNguyen

Reply to this Message

ADG - 24 Jun 2006 11:45 GMT

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

Signature

Tony Green

> I have a problem
> The "A3" cell 's formula contain "A1" and "A2"
[quoted text clipped - 4 lines]
> value is
> Please help me !

Reply to this Message