Check boxes in drop down box
 

Hey guys,

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

Is this possible??

Thanks!!
Molly

Check boxes in drop down box
 

Not using data|validation.

Molly wrote:

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

Check boxes in drop down box
 

What would be the best way??

Thanks for your response,
Molly

On Aug 15, 12:11*pm, Dave Peterson wrote:
Not using data|validation.

Molly wrote:

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

Check boxes in drop down box
 

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 wrote:

What would be the best way??

Thanks for your response,
Molly

On Aug 15, 12:11 pm, Dave Peterson wrote:
Not using data|validation.

Molly wrote:

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

--

Dave Peterson

Check boxes in drop down box
 

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

Thanks,
Molly

Check boxes in drop down box
 

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 wrote:

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

Check boxes in drop down box
 

On Aug 15, 2:52*pm, Dave Peterson wrote:
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 wrote:

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

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

Molly