Multiple checkoxes

Hi,

I have an excel sheet in which Column B has a list and Column C has corresponding items. Column D has the checkboxes.

Please see the attachment.

The user selects Category B from column B , and then selects item 2 using the checkbox in column D. Cell C33 displays item 2 is selected.
The user now selects item 5. The previous item is unchecked and cell C33 displays item 5.

How do you do that?


Please reply

Kapil.

One way:

Right click first checkbox and select Format Control.. in the Cell Link field of the Control tab, enter a cell reference, say $H$1

Repeat for each checkbox consecutively assigning them to cells in column H... (ie. $H$2, $H$3....)

You can then Hide column H, if desired.

Then formula in C3:

=IF(COUNTIF(H:H,TRUE),MATCH(TRUE,H:H,0),"")

This will return position of first checked box...(if one or more are selected).

You should then use OptionButton enclosed in a GroupBox

So remove the checkboxes..

Click GroupBox and draw the box in the area you want the option put.

Click OptionButton and draw with groupbox, repeat and organize

Then rightclick any Option and select Format Control and enter $C$33 in the Cell Link field.

If your options are aligned, then use another cell for cell link and then use Index() function to find corresponding item..

e.g.

=INDEX(C5:C10,X1) where X1 is the cell link for the options and C5:C10 is the corresponding range of items to your options.