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.

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

What would be the best way??

Thanks for your response,
Molly

On Aug 15, 12:11*pm, Dave Peterson <peter...@verizonXSPAM.net> 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

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 <peter...@verizonXSPAM.net> 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

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.



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

On Aug 15, 2:52*pm, Dave Peterson <peter...@verizonXSPAM.net> 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