Thanks for looking and the link, I think it was one of the resources I used to get this far. The multiselect portion is working but I am trying create another CC dropdown that would populate different lists based on the selections of the existing userform. The additional drop down I am trying to get working would not need to be multiselect as well, just a secondary list dependent on the userform.



If I can make this work I would ultimately like another CC dropdown as well that would populate based on the choice in the first drop down. So hopefully I will end up with three levels of selections. The first being the existing userform, then a dependent drop down, followed by another dependent drop down.



I recently found your website (which is awesome!) and the only thing I could find close to this would require an outside data source, such as excel or another word doc. I was hoping to keep this all contained within the VBA.


Thank you again for any insight you can provide!