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

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

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