Checkbox List in VBA?

[Freddie]

does Excel has CheckboxList object like the ones in normal VB?

i need to provide different number of checkboxes options based on
different cases. (E.g: case 1, i need to display 6 checkboxes, case 2
i need to display 11. both cases with different captions of course).
Of course i can do it in tedious way to create one individual checkbox
for each case, but i'm curious about it. It could save time and the
code will be neater as well

regards

freddie

 

[Bob Phillips]

Excel does not have a control array like VB if that is what you mean.

Rather than build/destroy objects, you could always create the maximum, and
hide and show as required.

 

[Andy Pope]

Hi,

Try setting these 2 properties on a listbox,

MultiSelect = 1 (SelectMulti) or 2 (SelectExtend)
ListStyle = 1 (ListstyleOption)

The use of multiselect will cause the normal optionbuttons to change to
checkbox buttons.

Cheers
Andy