Populate VBA Userform Listbox using SQL Recordset

Hi Guys,

I currently am running a MySQL Workbench server which stores Data that I am adding, retreiving, modify via an Excel interface that runs VB code.

Is it possible to populate directly into an ActiveX Listbox with values retreived from the record set from the database?

I realise that I could Populate the recordset to cells then tell the listbox to reference the cells to have it populate the list however i would prefer to directly populate the list box if possible

Please let me know if this is achievable

Kind Regards
Jordan

Yes, you can use:

Please Login or Register  to view this content.

Easy as, Thanks Kyle123!

Jordan