Link to home
Start Free TrialLog in
Avatar of Vignesh071498
Vignesh071498

asked on

List Box with multiple columns??

Hi !
I need help with this problem. I have a file(an excel worksheet) which has to be a  data source for a list box. How do I make the list box a multi column one so that all the columns in the worksheet can be displayed. Also, how can I write back the data from the list box to the worksheet. I intend to use the list box to sort the data

Thanks in advance.
Vignesh
Avatar of Jagar
Jagar

Use the ListView Control instead of the Listbox
Avatar of Vignesh071498

ASKER

Thanks for the tip. But I am unable to find the ListView control. Please help.

Thanks
vignesh
You can use a grid instead of a list, or go to third party list controls. VB list and combo controls support only one column.
ASKER CERTIFIED SOLUTION
Avatar of anthonyc
anthonyc

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks anthonyc for responding. But, how do I add the items to the ListView control? Will the AddItem method work? Also,  after the items are sorted, how to add them back to the file? Could you give me tips? I really appreciate the help.

Thanks