Select Cases and Comboboxes

Hello everyone. I have an outstanding problem that I could use some help on.

I have a userform that contains two comboxes. If the user selects value "A" in the first combobox, I want a specified range in a spreadsheet to be used as the rowsource for the second combobox.

If the user selects value "B" in the first combobox, I want a different specified range in a spreadsheet to be used as the rowsource for the second combobox.

Below is the source code.

Please Login or Register  to view this content.

Now this code is in the actual userform itself. A seperate module "Module 3" shows the form :

Please Login or Register  to view this content.

it's not working, and I cannot figure it out. Any help is greatly appreciated.

Hi Anthony,

I think you need to use

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

If that doesn't work try

Please Login or Register  to view this content.

See examples on http://www.ozgrid.com/VBA/select-case.htm

After searching the net for a long time it was easier to build a short example

See attached.

Here is the Case way to do this problem

Please Login or Register  to view this content.

Who would have guessed we needed "Case Is = " to make the syntax right.