The subject says it all, doesn't it??
How can I put the columns of my database in separate columns in my listbox? So I want to make a selection list in my listbox and the shown data comes from a SQL server. There are multiple lines.
Note that I'm totally new to vb, so be gentle with me ;)
you might find the DataGrid Control more usefull than a listbox for what youre trying to do.
Is that available in VBA for MS Office?
I don't find that component.
Thx 4 the quick reply.
OK I found it!
But when I try to use it, it says "cannot create... because of wrong licence"
Seems like I will have to use listbox after all.
I don't believe you need a license to work with the DataGrid. Are you sure you've set the correct component?
If you DO have that problem, then:
You can't do that in a listbox. How bout going for a flexgrid? It'll require you to explicitly code it, but you get the results you want. DO you know ADO?
Can I just insert a datagrid or do I first have to insert another component?