Combo Box ListFillRange Property - Non Adjacent Cells

When I add a combo box from Controls Toolbox, to my Excel worksheet, is it
possible to set non adjacent cells as the ListFillRange property of a combo
box? I have success with a range, but I am in need of specifying non-adjent
cells. ie: A3,A8,A15...not A3:A15.

Hi Tony

You can make a loop in code to fill it
Or in hidden column use
=a3
=a8
=a15
...
...
...

And use this range


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in message news:4F4C6A6E-FB25-4C8C-8100-9C4C7F7E3F64@microsoft.com...
> When I add a combo box from Controls Toolbox, to my Excel worksheet, is it
> possible to set non adjacent cells as the ListFillRange property of a combo
> box? I have success with a range, but I am in need of specifying non-adjent
> cells. ie: A3,A8,A15...not A3:A15.

Don't want to use code to do this...can it be done with just the property
setting?

"Ron de Bruin" wrote:

> Hi Tony
>
> You can make a loop in code to fill it
> Or in hidden column use
> =a3
> =a8
> =a15
> ...
> ...
> ...
>
> And use this range
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in message news:4F4C6A6E-FB25-4C8C-8100-9C4C7F7E3F64@microsoft.com...
> > When I add a combo box from Controls Toolbox, to my Excel worksheet, is it
> > possible to set non adjacent cells as the ListFillRange property of a combo
> > box? I have success with a range, but I am in need of specifying non-adjent
> > cells. ie: A3,A8,A15...not A3:A15.
>
>
>

> Don't want to use code to do this...can it be done with just the property
> setting?

No

But you can also use this :
Or in hidden column use
=a3
=a8
=a15
...
...
...

And use this range

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in message news:24A1C5D3-FC33-4D0F-BC4A-30FB00785CEB@microsoft.com...
> Don't want to use code to do this...can it be done with just the property
> setting?
>
> "Ron de Bruin" wrote:
>
>> Hi Tony
>>
>> You can make a loop in code to fill it
>> Or in hidden column use
>> =a3
>> =a8
>> =a15
>> ...
>> ...
>> ...
>>
>> And use this range
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Tony_VBACoder" <TonyVBACoder@discussions.microsoft.com> wrote in message
>> news:4F4C6A6E-FB25-4C8C-8100-9C4C7F7E3F64@microsoft.com...
>> > When I add a combo box from Controls Toolbox, to my Excel worksheet, is it
>> > possible to set non adjacent cells as the ListFillRange property of a combo
>> > box? I have success with a range, but I am in need of specifying non-adjent
>> > cells. ie: A3,A8,A15...not A3:A15.
>>
>>
>>