VBA to populate userform listbox from a table

[ritco]

I am trying to find the correct VBA syntax to populate a listbox (on an Excel userform) with column headings, from a table reference.

The following code works but does not display column headings:
******************************************************************************************
Dim reqmstrRnge As Range

Set reqmstrRnge = ThisWorkbook.Worksheets("DataTbl").Range("tbl_ReqLogMstr")

.lstDatabase.ColumnCount = 16
.lstDatabase.ColumnHeads = True
.lstDatabase.List = reqmstrRnge.Cells.Value
*****************************************************************************************

I originally used .rowsource before I converted the data sheet into a table. I assume I'm not using correct syntax or table references don't work with .rowsource.
I have not been able to find anything on the web for this that works.
Any thoughts?

 

[strive4peace]

hi @ritco,

does tbl_ReqLogMstr include the column headings in the fefinition? To find out, go to the Formulas ribbon tab, and then the Name Manager

 

[Isaac]

Is the listbox's ColumnHeads property set to True?

Honestly, I usually forego the in-listbox headers, as I have found them to be inferior in various ways (but I can't remember what those are now, it's been about 10 months since I did that) - and draw labels on screen above the listbox object, instead.