How do i input data into a 2nd column in a listbox?

[Devitt]

How do i add data in to a 2nd column on a listbox..
i can get the second column showing but no matter wat i do all the dat
goes in the 1st column.. please help this is really important for me.
thanks in advanc

 

[Devitt]

-BUMP- :mad

 

[mangesh_yadav]

where do you have the data to be displayed in the listbox.
You can do this way:
your data lies in cells A1:B2 as follows
abc pqr
mno xyz

in the properties,
put sheet1!A1:B2 in the listfillrange
put 2 in columncount
put 20, 20 (for e.g.) in columnwidth



mangesh

 

[Tom Ogilvy]

ListBox1.ColumnCount = 2
for i = 1 to 10
with listbox1
.AddItem "item" & i
.List(.Listcount-1,1) = "2ndColumnItem" & i
End with
Next