View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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/