<div>
You can write the recordset data directly into cells and refer the range into the listbox rowsource. No loop needed.<br />
<br />
Kris
</div>


You can write the recordset data directly into cells and refer the range into the listbox rowsource. No loop needed.

Kris

<div>
Please ignore my above post, I haven't fully read your question :(<br />
<br />
Kris
</div>


Please ignore my above post, I haven't fully read your question :(

Kris

<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
<b>Excel 2007</b><br />
<br />
I have a listbox on a userform that I'm populating by looping through a recordset.<br />
<br />
Because this is excel and not access, I cannot set the rowsource of the listbox to anything other than a range, and so I'm currently not seeing any headers.<br />
<br />
Does anyone know of a way around this programmatically? I'm not particularly enthusiastic about creating a temporary area / range for my recordset just so that it can be a rowsource.<br />
<br />
Thanks<br />
<br />
Rgds
</div>
</div>


Hi All,

Excel 2007

I have a listbox on a userform that I'm populating by looping through a recordset.

Because this is excel and not access, I cannot set the rowsource of the listbox to anything other than a range, and so I'm currently not seeing any headers.

Does anyone know of a way around this programmatically? I'm not particularly enthusiastic about creating a temporary area / range for my recordset just so that it can be a rowsource.

Thanks

Rgds

Excel listbox with headers

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.