Recordset to Listbox, no application.transpose
 

Hello,

I've seen a couple of replies from people in the forum on how to create a
recordset and then transfer values to a listbox.

The general answer is:

frmUser.listbox1.list = application.transpose(rsdata)

However, I tried that and didn't see a application.transpose. I did see an
application.worksheetfunctions.transpose. That does not work.

Error message: "Unable to get the Transpose property of the
WorksheetFunction class".

I am using Excel 2007.

Can someone shed some light on how to add a recordset to a listbox?

Thank you.

Tony