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

--
Message posted from http://www.ExcelForum.com

-BUMP- :mad

--
Message posted from http://www.ExcelForum.com

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


---
Message posted from http://www.ExcelForum.com/

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

--
Regards,
Tom Ogilvy

"Devitt " wrote in message
...
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 data
goes in the 1st column.. please help this is really important for me..
thanks in advance


---
Message posted from http://www.ExcelForum.com/