| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| compare 2 column cells and return the adjacent columns cells data of the cell | Excel Worksheet Functions | |||
| Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
| Combo box - Listfillrange | Excel Discussion (Misc queries) | |||
| Loosing combo box ListFillRange | Excel Programming | |||
| Combo box property | Excel Programming | |||
Linear Mode
