You can't. Only if you bind the listbox to data in the worksheet - this
means using the rowsource/listfillrange property.

--
Regards,
Tom Ogilvy


"in-over-his-head-bill" wrote:

This is probably (and hopefully) simple, but my eyes are seeing blurry from
all the time in the help screens and I still can't find the solution.

I have a recordset . I have a multi-column list box with columnheads set to
true.
I have assigned values from the recordset to the list box as follows:
lst.Column() = rs.GetRows

How in VBA can I populate the column headings in the list box with the
column names in the recordset (e.g., rs(0).Name)

Thanks for any help.