Hi,
I have created a userform with 3 dependant combobox and they work fine except when user changes value of the box. They pop up with error "Invalid Input Value”.
"TeamComboBox" is 1st selection Box that determines value for "ThreadComboBox" and similarly "ThreadComboBox" determine value for "SubThreadComboBox". Not sure what I am missing to get values blank/reset if user changes the initial value of any of combobox.Need combobox contents to go blank or reset once value changes.
Below is the code I am using for same.
Bookmarks