macro to create the same graphs for different worksheets

Hi,

I've just started using VBA. I have 18 worksheets with identical data in them ("FB1" to "FB18"). I want to be able to make a bunch of different graphs for each worksheet (the same graphs for each worksheet) and plot them in another worksheet called "Plots". It would be great to have a button with a list box (or some sort of drop down menu/selector) that allows me to control which worksheet i am creating graphs for (i have played around a bit with the combo box to no avail...) and that plots the graphs when clicked.

I have the code to plot the graphs i want for each worksheet.

Formula:

Please Login or Register  to view this content.

Thanks!

Dan

I fiigured out how to make a button that i can press to run the graphing macro, just haven't learnt how to make a selection list to choose which data to graph yet....