Hey all,
So I'm made a userform with two comboboxes, let's call them "combobox 1" and "combobox2". I, as a user, can select an option in ONLY ONE OF THE COMBOBOXES. Once that combobox is selected I can then load a chart based on the selection.
HOWEVER, I want both comboboxes to work independently from each other, meaning that if the user chooses to select an option in combobox1, then the combobox2 cannot be used, and if the user chooses to select an option in combobox2 then combobox1 cannot be used. BUT, I don't know how to code for this. I'm only able to code so that only combobox1 can take commands and display a chart. If I try to select anything in combobox2, I don't get anything.
Thanks a lot
So I'm made a userform with two comboboxes, let's call them "combobox 1" and "combobox2". I, as a user, can select an option in ONLY ONE OF THE COMBOBOXES. Once that combobox is selected I can then load a chart based on the selection.
HOWEVER, I want both comboboxes to work independently from each other, meaning that if the user chooses to select an option in combobox1, then the combobox2 cannot be used, and if the user chooses to select an option in combobox2 then combobox1 cannot be used. BUT, I don't know how to code for this. I'm only able to code so that only combobox1 can take commands and display a chart. If I try to select anything in combobox2, I don't get anything.
Thanks a lot