Populate data in 2 column listbox using vba

Hi All

I am using Excel frontend and Access backend for my project. Now I want to write the code that will execute when the userform1 is loaded and populate data from Access table in to the 2 column listbox. I have written the following code but that doesn't work properly.

Please Login or Register  to view this content.

Hope anyone can help me in this.
Thanks

Can anyone please help me to resolve my problem?

Many Thanks

Hi guys

I can't understand why the following code gives me "Runtime error '-2147352571(80020005)' Could n't set the list Property.Type mismatch"

Please Login or Register  to view this content.