Goal Seek with command button

[zulychg]

does someone can help me or let me know how to do set goal seek through a command button? Any help will be appreciate.. thanks alot :

 

[Fazza]

Hi,

Can you please post a simple sample & description of what is required? Thanks, Fazza

 

[zulychg]

goal seek

I want to a break even analysis

Since I need to do that everyday using a fixed template. I have the sensitivity 80% and the NPV I want o know what percentage of sensibility will give me an cero NPV.... I don't want to use the goal seek function every time. Instead create a command button that will allow me to do so... , I don't really have an example yet since I'm still working in the template...

thanks

 

[Fazza]

Well, it should be pretty simple. It is usually just one line of code.

The macro recorder will show you how it is.

Suggest you use defined names for the particular cells that you need to reference and then they will stay correct as row/column changes are made to the worksheet. (To avoid having something like "B1" in your VBA and then adding a new column. The VBA will still refer to "B1" although you will want it to be "C1" in this example; using a named range overcomes this potential problem.)

regards, Fazza