Thank you for viewing this request.
Details:
I have 2 lists: Category ID; Task ID.
There is a 1 to many relationship from Category ID --> Task ID, meaning that Task ID can be associated with only 1 Category ID; but, multiple Task IDs can share the same Category ID.
Category ID = Broader Description | Example: Continent: North America
Task ID = Granular Description | Example: Since North America was selected only Canada, 'Merica, and Mexico should populate, not the rest of the countries.
Question:
When creating a dropdown list in a user form, is it possible to for Country Dropdown list to be filtered based off of what was already selected in Continent dropdown list?
Images for Reference:
This is what I want it to look like but for user form in VBA
