I am trying to create a VBA code that does two things: automatically runs goal seek to update as inputs change, and references a cell containing a formula for the target value.

I want to:

Set cell I24
To the value that is shown in cell G9 (which contains a formula, and the value in the cell will change as other inputs change)
By changing cell F24

Any help on a VBA code that would accomplish this?

Thank you!