Check boxes in drop down box

[Molly]

Hey guys,

I want to have a drop down box (Data-Validation-List) with check boxes
inside of it.

Is this possible??

Thanks!!
Molly

 

[Dave Peterson]

Not using data|validation.

Hey guys,

I want to have a drop down box (Data-Validation-List) with check boxes
inside of it.

Is this possible??

Thanks!!
Molly

 

[Molly]

What would be the best way??

Thanks for your response,
Molly

 

[Dave Peterson]

If you want a dropdown box (single selection), then you could use a combobox
from the control toolbox toolbar.

After you add the combobox, right click on it and choose properties.
(make sure you're in design mode (another icon on that same toolbar).
Look for ListStyle
and change it to
1 - fmListStyleOption
(this provides a button/circle -- not a checkbox)

If you want to be able to choose several options, you can use a listbox from the
control toolbox toolbar.

Change the ListStyle property the same way.
And change the MultiSelect property to:
1 = fmMultiSelectMulti

You'll either see a button or a checkbox depending on that multiselection
setting.

 

[Molly]

When I do that it creates a box but there is nothing in it. It doesn't
create a checkbox or button.

Thanks,
Molly

 

[Dave Peterson]

You have to add the items to the combobox/listbox someway.

One way is to use the properties dialog and type in the address of the range to
use in the listfillrange property.

If you're using a combobox, you may want to type in an address into the
linkedcell property, too.

 

[Molly]

You have to add the items to the combobox/listbox someway.

One way is to use the properties dialog and type in the address of the range to
use in the listfillrange property.

If you're using a combobox, you may want to type in an address into the
linkedcell property, too.

Okay, thank you very much for all of your help.

Molly