How do i input data into a 2nd column in a listbox?
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 |
How do i input data into a 2nd column in a listbox?
|
How do i input data into a 2nd column in a listbox?
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/ |
How do i input data into a 2nd column in a listbox?
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/ |
All times are GMT +1. The time now is 03:54 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com