ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automating Goalseek When moving points on a graph (https://www.excelbanter.com/excel-programming/293288-automating-goalseek-when-moving-points-graph.html)

Sean[_7_]

Automating Goalseek When moving points on a graph
 
I have created a macro that activates points on a graph so
I can move them to change the slope of the graph. After I
move the points, the goalseek input box appears, and it
requires me to enter the cell reference so it can change
the value of that cell, then it finds a solution and asks
if I want to keep the solution. I want the macro to
automatically enter the cell reference and click 'ok' to
keep the solution after I move the graph point. Is there
a 'wait for user entry' command or something else I can
use to do this?


All times are GMT +1. The time now is 08:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com