Populate userform combo box with named dynamic list

Excel 2007 and very new to VBA...

I have a userform (named "QAReviewForm") with a combobox (named "cboSupName"). I want it to populate with my named range "SupList".

FYI, the SupList is found on sheet 2, "Administrative Menu" in column E. E1 contains the heading "Supervisors", and my named range formula is

Formula:

Please Login or Register  to view this content.

My code is has follows:

Please Login or Register  to view this content.

When it runs, my form opens and the combobox is there, but nothing appears as options for me to select (yes, I have some values in column E).

Any help is greatly appreciated.

OK, I get that now...

I have deleted the Userform_Initialize routine altogether... though I assume it needs to go somewhere?

But still, my basic problem is that on my QAReviewForm, I intend to have several combo boxes. I was trying to get the first one, Supervisor Name, to populate from the Admin Menu sheet (dynamic range)... eventually, the Employee Name will do the same, and Program # and Location combo boxes will populate from named ranges on the LookupLists sheet.

I'm sure I'll have more questions and challenges down the road, but right now I'm stuck on this one.

HeyInKy

QA Form draft3.xlsm

The Userform_Initialize routine goes in the UserForm which is actually a Class Module with a GUI.
Assuming the relationships between the different lists are taken care of by the dynamic, named ranges, put the name of the named range, as a text string, in the RowSource property of the control to populate the List.


Sent from my iPhone using Tapatalk

The other option, assuming the named range has Workbook scope, is like this...

Please Login or Register  to view this content.

I'd be interested in Norie's view, but as far as I know RowSource works ok.


Sent from my iPad using Tapatalk

Originally Posted by Norie

Put this code in the userform module.

Please Login or Register  to view this content.

This answer worked great. Thanks @ Norie. You're awesome!

Originally Posted by Norie

coolblue

Populating with RowSource can cause problems later, mainly because it's kind of a 2 way thing.

Ok, can you give an example?
When you say it causes problems later, what circumstances are you talking about?

My understanding is that it's one way: data comes in from RowSource and out (if you click on another control) to ControlSource.

I mean, the List structure is nice... being a nice juicy variant array and I use it for reading and setting the Selection (I've noticed that .Value is definitely buggy in ListBoxes, so I avoid that one and ControlSource is not very responsive)...
But it's tempting to leave the upload to native code in RowSource.

I'm just curious to bottom out what works and why.


Sent from my iPhone using Tapatalk