Hello,
I appreciate your time and expertise!
I am looking to set up two combo boxes where the second combo box's values are derived from a table that is filtered based on the first combo box value.
Here is a picture of the code that I am using: Combobox-dependentValues.JPG
The set "Case" that is highlighted returns nothing in the second combobox, and the "Case" below returns the hidden and visible values. After the filter is applied, I am looking to only get the visible cells.
The file is attached, and this section of the code is located in UserForm.Initialize.
Thank you,
Adam
Bookmarks