Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 20
Default 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?
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
moving data points in chart sabdurra Charts and Charting in Excel 2 June 17th 08 05:09 PM
Change spreadsheet by moving graph points? CourtneyNeedsHelp Charts and Charting in Excel 5 April 18th 08 02:32 AM
Moving chart points PCCR Charts and Charting in Excel 2 March 2nd 08 12:16 AM
Please Help! Automatically moving decimal points Noodles Excel Discussion (Misc queries) 3 January 29th 08 09:44 PM
Automating GoalSeek - why doesn't this code work? Jeff Donville Excel Programming 0 September 11th 03 04:55 PM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"