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.

Combo Box ListFillRange Property - Non Adjacent Cells
 

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" wrote in message ...
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.

Combo Box ListFillRange Property - Non Adjacent Cells
 

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" wrote in message ...
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.

Combo Box ListFillRange Property - Non Adjacent Cells
 

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" wrote in message ...
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" wrote in message
...
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.