De: JohnN Objet: Re: Linking a chart with spinner control Date : mardi 16 novembre 1999 20:51 I've had success doing it this way 1) Create a worksheet image of the data you want charted. (chart this data, when the underlying data changes the chart will automatically change) 2) Gather the other data in a series of sheets. (each sheet is a data set) 3) On a separate 'control' sheet or on the sheet constructed in step 1, pick a cell outside of the graphing data to use as a lookup value. You will put a number of from 1 to N in this cell. N is the number of data sets (separate worksheets). 4)Using VBA use the copy method to copy data on sheet x (x is the number in the cell in step three) over the data created in the first step, this will cause the chart to change to the new data set. 5)Create a form in a VBA that contains the text box, spinner, ... control. When the control is changed, the module associated with that change then changes the look up value on the control sheet. (you can use a variable in VBA instead of a cell, but it's easier to test this way. If you are only changing an input to a formula, just tie the spinner's value to the cell(s) that change. The chart will automatically update. * Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!