Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Goal Seek and problem solving excel function using VBA
|
|
|
The UK's most regular 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. |
Goal Seek and problem solving excel function using VBA
Resolved · Medium Priority · Version 2007
Reply 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
For upcoming training course dates see: Pricing & availability
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.
|