comparing check box values to a table

  • Thread starter Thread starter Markathepub
  • Start date Start date
M

Markathepub

Hi,

Hope you can help, I have a worksheet with five check buttons on it
Depending on the combination of buttons selected I want to select
value for use elsewhere in the sheet.

I've built a table with five columns which has every possible logica
combination but don't know how to get my check button link cells t
look at the table. compare them and select the result.

I've attached the file

thanks to anyone who helps

Mar
 
Mark,

A suggestion.

If checkbox 1 is clicked, add/subtract 1 from a global variable
If checkbox 2 is clicked, add/subtract 2 from global variable
3, +/- 4
4, +/- 8
5, +/- 16

Then you can test the variable for any value between 0 and 31, and act
accordingly.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top