solution required 
Author Message
 solution required

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



Thu, 08 Jul 2004 06:33:58 GMT  
 solution required
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


Quote:
> 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



Fri, 09 Jul 2004 02:04:36 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Telephony Solution Required

2. A passwording solution required can anyone help

3. ComboBox solution required

4. A passwording solution required can anyone help

5. Text to Date Conversions - Solution required

6. Simple query solution required

7. Office Solution Required

8. A passwording solution required can anyone help

9. Solution required for dot problem

10. Advise on Outlook 98 Solution required


 
Powered by phpBB® Forum Software © phpBB Group