excel vba populate listbox from mysql recordset

Hi everyone, what I am trying to do is to populate a listbox from an event trigger from while I write, I have seen it in .net examples like this one over here http://www.youtube.com/watch?v=YbzQbbQJQGg, but it doesn’t work same way in vba excel, and what I trying to do is the same thing is show in the video.

As you can see in the video the only difference is that I am connecting to a mysql database and the example shows a connection to access database, but the logic is the same as I need for what I want to do.

If you look after minutes 6 of that video, you can see the programmer implement methods such as AutocompleteCustumSource to populate the text box. That is what I want to do.

I know that it can be different in vba but I thing I have to deal with a textbox and a listbox at the same time, and build a method that everytime the user types something, it triggers an event to populate the listbox.

My question is ... am I right trying to do this?, there is anyother way easier of doing this ? Thanks for your help

I have a code that allows me to query the database.

the problem I have is that I need the query to perform each time the user types in the textbox.

I have the following code but it does not work.

I really appreciate who can help me.

Please Login or Register  to view this content.