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
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