Anomandaris
06-01-2009, 07:07 AM
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
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