Can’t populate (Initialize) multiple ComboBoxs on UserForn

[julhs]

I have blundered my way to this point and have got something that vaguely works but at the end of the day it’s not working.
Attached is the rough draft of where I’m at with it.

What’s not happening it the ComboBoxes are not populating from the Ref sheetlist, and when I manually add values to them I can’t get it to enter them either

Any suggestions as to where I have gone wrong would be greatly appreciated

[mikerickson]

This worked for me.

Please Login or Register  to view this content.

[bakerman2]

Thouroughly check all the names of the named ranges in your code you use to fill your Combo's against the names you have given them on your worksheet.
Notice the differences in writing.
After that all works fine.

[julhs]

Hi Bakerman2, thanks for response.

I did find a one typo, have checked range names but still not having any joy. Think it is just a case of me not understanding my own range referencing, could you be more specific as to where you identified the problem, as for the life of me I can’t find it.

MikeRichardson
Thanks Mike, not tried yours yet. Looking at points Bakerman2 made at the moment

[julhs]

What a !!!!!!!!!!!!!!!!!
The whole problem all along had been that at I had put

Please Login or Register  to view this content.

(beining the actual Userform title) instead of simply

Please Login or Register  to view this content.

Changed that and every thing ok.

Mark, tried yours out of appreciation. Admittedly harder for a Vba novice like me to follow but works just as well, I will file it for future reference

Now have the other parts of the UserForm to complete

Many thanks to you both

[bakerman2]

You're welcome and thanks for adding rep points.