Scrollbar

[Anomandaris]

Hi guys,
Some of you may already be familiar with the file here, esp. xld and mdmac, who have helped me get this far
what I'm looking to do is connect a scrollbar to a set of data. The idea is that using the scrollbar we'll select the data
picked for teh calculation. There are 2 scrollbars one to set the starting date, and one for ending date. The scrollbars are
on the sheet 'chart', but it relates to Table 2 data on the sheet 'dataforchart'. So if we select from 29 April to 8th May
then only that range of data should be calculated for Table 1 on 'dataforchart'.
any idea how i should do this?
many thanks

[Bob Phillips]

When do you want this to kick in?

As I recall, the Button 14 click fires the macro to get the data for Dartachart. As no dates are known at this point it seems to me that we should generate the data, then use the scrollbars to limit that data after the evnt so to spaek.