Thank you Greg, am glad visitors to this forum will have a choice. I can't write code, but I can to a small degree read and understand it.
I can't tell if your version allows to add levels of dropdown as needed, regardless I'm sure anybody that can code would be very impressed by reading your creation.
Paul's version is the "for dummies" like me who need code that can easily be modified to my purpose. Paul's version works great for what I need which is my boss want's me to learn a complex job function, we have no training manuals or tools. We learn by senior staff teaching us. I thought this is ridiculous and with my limited knowledge of coding, but being a "power" user of MS Office, I could come up with something. The dependent dropdown in my case it the perfect options.
Thank you all for giving of your time, I'm sure you don't fully know how much it's appreciated.
Pierre