Goal Seek and problem solving excel function using VBA

Resolved · Medium Priority · Version 2007

Tue 6 Dec 2011, 17:47 Delegate 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:50 Trainer 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.xls

Thu 15 Dec 2011: Automatically marked as resolved.

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Adding Rows or Columns in an Excel 2010 Worksheet

If you want to add a row to an Excel spreadsheet, these are the simple steps you should take:

With your mouse, right click on the row header below where you want the new row to be added. Then, click Insert.

Follow exactly the same steps if you want to add a column to an Excel worksheet, right click on the column header, choose Insert and the new column will be inserted to the left of the selected column.

View all Excel hints and tips