Dose anyone know how to use excel's VBA?

Question

I am trying to graph the sine and cosine functions on excel and want to put them in a drop down box as well as put the amplitude and period in a scroll bar. I need to graph it and have it change with everything else. Any ideas?

Answer 1

Hi,

You don't need VBA at all to accomplish the things you desire.

Examples of how to use the SINE function are in Excel's help. Just type the word SINE and click search for how to use this function.

Once you have a range of cells with sine values in them you highlight them and click the graph (chart) button on the standard toolbar.

Your graph is automatically linked to the data, so whenever there's a change in the data it's instantly reflected in the graph.

-Jim