Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL
I HAVE TO BRING THE GOAL SEEK DIALOGUE BOX, EVERY TIME I MAKE A CHANGE IN THE
DATA. CAN GOAL SEEK BE PERMANENTLY SET , SO THAT I GET ANSWERS AUTOMATICALLY EVERY TIME I CHANGE THE DATA & NOT HAVE TO REFER TO GOAL SEEK EVERYTIME. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW DO I SET PERMANENT GOAL SEEK IN EXCEL
You could record a macro of your use of Goal Seek. Perhaps something
like: Public Sub DoGoalSeek() Const dGOAL As Double = 100 Const sCHANGINGCELLADDRESS As String = "A1" Const sTARGETCELLADDRESS As String = "J10" With Worksheets("Sheet1") .Range(sTARGETCELLADDRESS).GoalSeek _ Goal:=dGOAL, _ ChangingCell:=.Range(sCHANGINGCELLADDRESS) End With End Sub If you want you can make it work automatically by putting this in your worksheet code module (right-click the worksheet tab and choose View Code): Private Sub Worksheet_Change(ByVal Target As Excel.Range) DoGoalSeek End Sub In article , YKPURI wrote: I HAVE TO BRING THE GOAL SEEK DIALOGUE BOX, EVERY TIME I MAKE A CHANGE IN THE DATA. CAN GOAL SEEK BE PERMANENTLY SET , SO THAT I GET ANSWERS AUTOMATICALLY EVERY TIME I CHANGE THE DATA & NOT HAVE TO REFER TO GOAL SEEK EVERYTIME. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
goal seek | Excel Discussion (Misc queries) | |||
MS Excel: Why would the Goal Seek option be dimmed for a book? | Excel Discussion (Misc queries) | |||
Excel - Goal Seek | Charts and Charting in Excel | |||
Goal Seek | Excel Discussion (Misc queries) | |||
Goal Seek | Excel Worksheet Functions |