No. that would put both values in the first column.

--
Regards,
Tom Ogilvy


"augustus" wrote in message
...
Is there other way to AddItem to multi-column, such as

Sheet1.ComboBox2.AddItem RS.Fields("test01").Value & ";" &
RS.Fields("test02").Value

I read this somewhere on the web, it didn't specify as a method for VBA,
but
for VB.
I tried, but doesn't work

Thanks

"Tom Ogilvy" wrote:

Because additem increases the size of list, where your method doesn't.

--
Regards,
Tom Ogilvy


"augustus" wrote in message
...
hi,

Why is it that I can't populate a combobox the following way:

Sheet1.ComboBox2.List(intRow, 1) = RS.Fields("test01").Value
Sheet1.ComboBox2.List(intRow, 2) = RS.Fields("test02").Value
RS.MoveNext
I got this idea based on the Help file from Excel 2003
I have defined the number of Column = 2

i tried Dick Kusleika way, without problem:
Sheet1.ComboBox2.AddItem RS.Fields("test01").Value
Sheet1.ComboBox2.List(Sheet1.ComboBox2.ListCount - 1, 1) =
RS.Fields("test02").Value

thanks