How to use multi-column ListBox?

**Treacle** · 01-08-2009, 10:10 AM

Hi,

I am trying to use a ListBox with multiple columns. I have set the properties so that columncount is 4 and columnheads is true and I can see the four distinct columns when the code is run. However, I can only seem to add data into the first column. I have tried changing the bound column or textcolumn but when I use AddItem, it always puts data in the first column.

Can anyone give me an example of how to populate all the columns in a ListBox please?

Thanks

**royUK** · 01-08-2009, 10:15 AM

Where are you populating from? is the source on a sheet?

**Treacle** · 01-08-2009, 10:21 AM

It will eventually use an ADO Recordset but for test purposes I am just trying to hard-coded text to the columns. eg. ListBox1.AddItem "Hello".

How would I put "Hello" in the first column and "Goodbye" in the second one?

**royUK** · 01-08-2009, 10:35 AM

Like this

Code:

   With Me.ListBox1
        .AddItem "hello"
        .List(.ListCount - 1, 1) = "Goodbye"
    End With

**Treacle** · 02-16-2010, 05:18 AM

Great, that worked a charm! Thanks for your help.

Thread: How to use multi-column ListBox?

Thread Tools

Display

How to use multi-column ListBox?

Re: How to use multi-column ListBox?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions