Hi,

I'm looking for a VBA solution to the following problem:

I have a  3 tables of numerical values arranged in a row x column format.
This is Table 1:

Table 1

        Cat1    Cat2    Cat 3    Cat4
D1    3.2      4.8       5.6       6.4
D2    2.9      3.2       4.6       5.1

I have a form containing:  3 OptionButtons for Tables 1, 2 & 3 and 2
OptionButtons for D1 & D2 and 4 CheckBoxes for Cat1 thru Cat4.

Assumming OptionButton1 for table 1 is selected, I then need a routine to
run where OptionButton2 for say D1 is selected and CheckBox1 for Cat1 is
selected to return a value of 3.2 into the form label from the above array.

Has anyone got any ideas?

Thanks, Paul

Sure,
Just set up a 3 dimensional array with the 3 tables of values stored in it.

Then convert the selected controls to the appropriate index numbers and use
these numbers to index into your array to retrieve the numbers.

Assign the result to the caption of your label.

Regards,
Tom Ogilvy