How do you use ComboBox's as worksheet names in SUM formulas

F

fifthhorseman

I am trying to write a SUM formula that would use the values of tw
combo boxes to SUM a range of worksheets.

The values for these boxes are in cells:
Analysis!B7
Analysis!D7

These values are also dates, which are also the names of the worksheet
in the workbook. Lets say the selected dates in the two combo boxe
are 21-Jun-04 and 12-Jul-04, which means the two cells above would hav
the following values:

Analysis!B7 = 21-Jun-04
Analysis!D7 = 12-Jul-04

These cells are in text format. There is a worksheet named 28-Jun-0
in between the previously named sheets, so I am able to sum all three.
Ill say A1 is the cell I want to add on each sheet. This is what
want to be able to do:

=SUM('21-Jun-04:12-Jul-04'!A1)

except I want it to be user-selectable, kinda like this:

=SUM('ComboBox1.Value:ComboBox2.Value'!A1)

Any help would be well appreciated.

Thanks,
Dou
 
Top