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


--
Regards,
Tom Ogilvy


"ExcelMonkey" wrote in message
...
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