How to use the UserForm Initialize event to Initialize 3 listboxes in the same userform

Good Day to all,

So I have a UserForm which has 3 listboxes which I want populated with information from 3 separate sheets when the useform is loaded.

I can populate one listbox easily, but when i try to do multiple listboxes in the same userform I run into problems

The following is what I use to arrange listbox1 and populate listbox1

Please Login or Register  to view this content.

I have this code in a module

This code to initialize the userform

Please Login or Register  to view this content.

This is what I came up with to accommodate my 3 listboxes

Module one code

Please Login or Register  to view this content.

And my UserForm Utilize event

Please Login or Register  to view this content.

Can someone Please point out what i'm doing wrong as this is not working and i am officially stuck

Re this quote from Norie

If you do you could just call all 3 subs from the Initialize event

could you give a short example of how to do this?

Pimp_mentality,
Referencing Sheet by its CodeName makes a little complex for this one.
You need to check "Trust access to the VBA project object model" see https://support.microsoft.com/en-us/kb/282830.

Please Login or Register  to view this content.

Originally Posted by bakerman2

I'm correcting you cause you're wrong. What's the Resize for do you think?

Yes it seems I am. I stand corrected sir

Good day Norie

I tried the above but received a runtime error 13 "type mismatch"

I really don't know why

Good Day bakerman2

As I am also interested in the method you posted

I tried the way you suggested (as i am genuinely interested in both methods) with no success. only listbox1 was populated but listbox2 and listbox3 did not populate

I'm confused, why not simply:

Please Login or Register  to view this content.

I don't understand why you seem to have the same code in a module and the userform

her is a sample of my form

Please Login or Register  to view this content.

re kyle123 I did try that but only list box one populated, the others did not

Re jindon,

This method works great, the VsortM sub is one I m not accustomed to but I am examining and googling so i can understand better exactly what you did so I can utilize the method in other projects I am working on

Hey guys thanks a millions for the help

Much appreciative