I am looking for a procedure that allows me to define specific values in a ComboBox and based on the value selected send information for range B1, B2, B3, B4, B5.
The idea is to have Dev, Qual, Prod values in the ComoBox and based on this send information for the ranges listed bellow.
I prefer to manage values in an Array instead of defining specific range at worksheet level.
I attached dummy file in which I have already defined UserForm.
If you have questions, please contact me.
Thank you for your help.