Combobox2 dependent on Combobox1

Hi, and thanks for reading !
I've been constructing a pretty big userform in the attempt to automate grade recording for my small private school. Through the help of this forum, I've learned so much, and am so appreciative of all your help !

The one thing I can't seem to get to work, even when i replicate examples from here is to get a combobox to display certain choices depending on the selection from another combobox.

I'm attaching a screen shot of the info in cells the way i'd like it to be displayed in the userform. I've intentionally put the data in cells this way, as I've seen working examples of what i want to do, where the author put his data in like this.

Combobox1 : the teacher selects his/her name
combobox2 : the classes that teacher assigns grades for come up

It seems like this should be relatively simple, but i can't get anything even close to a working model.

any help would be much much appreciated !

hi teacher,
see at this example from this forum!

as an option
see Sheet1 properties, in the left side, set visible to veryhidden and add yr button to Sheet2.
or

Please Login or Register  to view this content.

hi teacher,
well, it's very difficult to say ...
just try to make a test file with some of yr data, with yr real comboboxes name (ex. cboclass as ComboBox2) and see if this one is populated when you choose the teacher in the first combobox.
or add here yr entire code for this issue.

hope we can solve it

Here's an example that I use

or as an option see if this one solves yr issue.

hi Rob
glad it helped!