Check boxes in drop down box

  • Thread starter Thread starter Molly
  • Start date Start date
M

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
 
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
Click to expand...
 
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.
 
When I do that it creates a box but there is nothing in it. It doesn't
create a checkbox or button.

Thanks,
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.
 
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.
Click to expand...

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

Molly
 
Back
Top