3-tiered dependent combo boxes in userform using excel 2007

[sahas]

I have been able to cascade two combo boxes in the userform by using the "select case" statements however it becomes tedious with the third dependency. Is it possible to change the row source of the third combo box depending upon the selections in the first two combo boxes. I tried the following code but i gather i am lost:

Please Login or Register  to view this content.

Please Help!!!

[Norie]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code in [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

[sahas]

Sorry 'bout that... I have edited the post...

[Norie]

No problem.

There's one obvious problem with the code, & is the concatenation operator and you can't use it for the logical operator AND.

So replace & with AND.

[sahas]

Thanks but still doesn't work

[Norie]

In what way does it not work?

Can you attach a sample workbook?

[sahas]

OH! Sorry. It's working... I had forgotten to unquote the "With and End With" statements... Thanks a lot Norie..