98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Goal Seek and problem solving excel function using VBA
Goal Seek and problem solving excel function using VBA
Resolved · Medium Priority · Version 2007
Tue 6 Dec 2011, 17:47Delegate Vivek said...
Vivek has attended:
Excel VBA Intro Intermediate course
Goal Seek and problem solving excel function using VBA
Hello,
What is the general syntax and do we need to include any inbuilt library functions for the same?
Thanks,
Vivek
Fri 9 Dec 2011, 11:50Trainer Simon said...
RE: Goal Seek and problem solving excel function using VBA
Hi Vivek,
Thank you for your question and welcome to the forum.
I have attached a spreadsheet with an example of VBA Goal Seek code. When you run the macro via the command button it will prompt you for a goal value(A1) and will then change cell B1 to achieve that goal.
The inbuilt functions are accessed by using the following line of code:
application.worksheetfunction.sum
I have attached a spreadsheet showing you the goal seek example.
I hope this answers your question.
Regards
Simon
Attached files...
Goal Seek VBA.xlsThu 15 Dec 2011: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Adding Rows or Columns in an Excel 2010 WorksheetIf you want to add a row to an Excel spreadsheet, these are the simple steps you should take: |
