Automating goal seeking in MS Excell
How can we automate the goal seeking problem in excell where the system prompts the user to give the value which is to achieved.
We may use VBA also for this purpose
Web Development
How can we automate the goal seeking problem in excell where the system prompts the user to give the value which is to achieved.
We may use VBA also for this purpose
by dklippert
Here's one crude macro that asks for a number:
Sub GoalSeek()
Dim GoalNumber As Integer
GoalNumber = InputBox("What is the goal", "Goal Seeker")
Range("B5").GoalSeek Goal:=GoalNumber, ChangingCell:=Range("F1")
End Sub
by akkureel
by akkureel
This discussion is closed to new replies.
Sort by Trending