Macro for goal seek value input

[z71dawg101]

Hello,

I need help with creating a macro and a button for an excel worksheet. I need the To Value in goal seek to be a specific cell, as in when the cell changes value I do not have to go to goal seek and change the value every time. I have no clue how to write a macro to do this. Any help would be appreciated!

Thanks!!!!!

Please comment on this thread if you are interested in helping and I can email you the spreadsheet.


I need the assumed real increase in contribution each year to be the by changing cell in goal seek, and cell K48 is the value. the set cell is k48

 

[BadgerRoad]

Welcome to the board.
I'm a little confused by which cells you want to use for what in Goal Seek so I created a macro using the following:
The "Set Cell" is A5
"To Value" is cell B1
"By Changing" is cell A4

Following is the Macro code

Sub Goal_Seek()
'
' Goal_Seek Macro
'

'
    Range("A5").GoalSeek Goal:=Range("B1"), ChangingCell:=Range("A4")
End Sub

 

[BadgerRoad]

I was a little brief in my response last night. If you need help getting the proper cells into Goal Seek or if you want to use a Command Button to invoke Goal Seek just respond and I will try to help you with that.