View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mika mika is offline
external usenet poster
 
Posts: 7
Default Adding items to the second column of a list box

Hi,

I am populating from a one dimensional array.

I have two one dimensional arrays, so I want to populate
the first column with values from the 1st array, and the
second coumn with values from the 2nd array.

Thanks,
mika
-----Original Message-----
if you are using the rowsource or listfillrange, just set

the reference to
two columns

Sheet1!A1:B20

Also, set the columncount property to 2

if not, how are you populating the listbox?

--
Regards,
Tom Ogilvy

"mika" wrote in

message
...
Hi,

I have a 2-column list box, but I can't figure out how

to
add items to the second column. Any help would be

greatly
appreciated.

Thanks,
Mika



.