Discussion Locked

Automating goal seeking in MS Excell

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

5 replies

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

This discussion is closed to new replies.