View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
mangesh_yadav[_134_] mangesh_yadav[_134_] is offline
external usenet poster
 
Posts: 1
Default 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/