Dump 2D array into Control

[ExcelMonkey]

I want to dump data into a useform control with columns.
Similar to the control you see when you open up a file
directory with Detail(i.e. multiple rows and columns). Is
there a control for this available in VBA? If so can you
name the column headings? I also want to be able to click
onto the results of each row/column.

THanks

 

[Tom Ogilvy]

Use the Listbox

If you want to use an array, then you can't have headings. If you want
headings you would have to put your data on a sheet.

You need to set the properties of the control to show the number of columns
as you have in your array.

to simulate headings, you could put labels or textboxes above your listbox.

Private Sub Userform_Initialize()
with Listbox1
.Columncount = 5
.List = MyArray
End with
End Sub

 

[Guest]

Thanks Tom. One more quick question. Can you adjust the
column width of each column within the listbox?

Thanks

 

[Tom Ogilvy]

Yes, but an explanation would be long winded. See the Columnwidths (note
the s on the end) property of the Listbox control.

An easy way to get there is to go to the object browser in the VBE, in the
search box, put columnwidths

Click on one of the columnwidths entries for combobox or listbox and hit F1.