Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Populating a multi column listbox with ADO Recordset | Excel Programming | |||
Filling a listbox whith recordset data | Excel Programming | |||
Application.Transpose in VBA EXCEL 2003 | Excel Programming | |||
Populating a multi column listbox with ADO Recordset | Excel Programming | |||
How to populate a multi-column activeX listbox on a spreadsheet with an ADO recordset | Excel Programming |