| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i call a macro from a cell
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 ! -- KhanhNguyen ------------------------------------------------------------------------ KhanhNguyen's Profile: http://www.excelforum.com/member.php...o&userid=33697 View this thread: http://www.excelforum.com/showthread...hreadid=555197 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do i call a macro from a cell
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 -- Tony Green "KhanhNguyen" wrote: 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 ! -- KhanhNguyen ------------------------------------------------------------------------ KhanhNguyen's Profile: http://www.excelforum.com/member.php...o&userid=33697 View this thread: http://www.excelforum.com/showthread...hreadid=555197 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Call Macro when Cell within Range Changes | Excel Programming | |||
| Automate a macro based on the value of a cell? (call Sub) | Excel Programming | |||
| Call a macro or sub based on the name of a cell? | Excel Programming | |||
| Call a macro or sub based on the name of a cell? | Excel Programming | |||
Linear Mode
