PDA

View Full Version : populate list box



talytech
06-11-2007, 11:50 AM
Does anyone know how to populate a listbox on an Excel userform with data from an Access recordset?

I have a listbox(ListBox1) on a userform in Excel. I've connected to an Access database and opened a recordset (myRst). I would like to populate the listbox with the data from the recordset. I'm unable to use the AddItem method because it only adds to one column. My recordset has 5 fields. How do I populate the listbox to have multi columns and headers? I've been struggling because it seems like from Excel the rowsource property only works with spreadsheet ranges.

Please somebody help me.

Ebrow
06-13-2007, 11:48 AM
Whats wrong with this answer?

http://www.vbaexpress.com/forum/showthread.php?t=13293

Edit Lucas: too many http's in your link...

lucas
06-13-2007, 01:24 PM
He just posted there yesterday the 12th. Guess he didn't get an answer here so it's just as well.