Multi column list box [Resolved]

[Pearso]

Hello All,

My understanding of VBA forms is that a list box can only contain one column of data. Is it possible to create a list box that has 5 or five columns of data, but each row is still a single selectable item.

Does anyone know who to do this.

[Ecniv]

Access? or userforms in excel/word?

Access you can. On the properties sheet>Format tab column count, and column widths. Also a column heads. Pick what you want there.
Same for combo and list boxes. If the column width is 0 then that column is hidden yet still available to be used.

[Pearso]

I would like to do it in Excel what i would like to do is make clumns A-C appear on a user form.

I'm looking that the listbox properties. there is BoundColumn, columnCount, Columnwiths and Columnheads. Which one of these does what? And how do i set them up.

Thanks

[Ecniv]

Attached is a test filling of a list box.
You need to open the form via the immediates window : Tools>Macro>VB Editor - Ctrl+G - ufrm(ctrl+space).open vbmodeless
Then flick back to excel sheet.
There should be a form there, click on refresh and it should pull the cells data into the list box.

Grab what you need from it. This is only one way to do this