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.
Printable View
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.
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.
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
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