| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple Ranges for Combo Box in Forms
Hi,
I am trying to add a combo box to a form that has the RowSource has multiple Columns with varying Rows in each columns... for example A9, D1:D41, I1:I3, N1:N15 and so on.... I have my calculation means to find out what is different ranges but how do I define that these all ranges to form the RowSource of the ComboBox. Many thanks in advance, Vishwa |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple Ranges for Combo Box in Forms
Are you trying to place the contents of the cells in these ranges into the
combo box OR the ranges definitions ? eg in list box contents of each cell in range(s) Cell A9 Cell D1 Cell D2 OR in list box the ranges as... A9 D1:D41 I1:I3 N1:N15 -- Cheers Nigel "call_Vishwa" wrote in message ... Hi, I am trying to add a combo box to a form that has the RowSource has multiple Columns with varying Rows in each columns... for example A9, D1:D41, I1:I3, N1:N15 and so on.... I have my calculation means to find out what is different ranges but how do I define that these all ranges to form the RowSource of the ComboBox. Many thanks in advance, Vishwa |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Multiple Ranges for Combo Box in Forms
Hi,
I am trying to update the contents of the COMBOBOX with the CONTENTS of the Ranges in question "Nigel" wrote: Are you trying to place the contents of the cells in these ranges into the combo box OR the ranges definitions ? eg in list box contents of each cell in range(s) Cell A9 Cell D1 Cell D2 OR in list box the ranges as... A9 D1:D41 I1:I3 N1:N15 -- Cheers Nigel "call_Vishwa" wrote in message ... Hi, I am trying to add a combo box to a form that has the RowSource has multiple Columns with varying Rows in each columns... for example A9, D1:D41, I1:I3, N1:N15 and so on.... I have my calculation means to find out what is different ranges but how do I define that these all ranges to form the RowSource of the ComboBox. Many thanks in advance, Vishwa |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Forms - Combo Box | Excel Discussion (Misc queries) | |||
| Combo Box Forms vs Active X | Excel Discussion (Misc queries) | |||
| Forms Combo Box | Excel Worksheet Functions | |||
| User Forms - Combo Boxes | Excel Discussion (Misc queries) | |||
| Forms Combo Box | Excel Discussion (Misc queries) | |||
Linear Mode
