I’m creating an Excel application for a client using VBA.
cboCity: City is dependent on Country.
cboSponsor: SPONSOR can be determined by Country/City.
cboAccountType: Account Type is dependent on Country, City and SPONSOR.
The client wants maximum flexibility in a UserForm that activates on WorkBook_Open to capture initial data to drive the worksheet. So, I must meet the following conditions:
User selects COUNTRY first.
• Filter cboCITY based on country THEN
• Filter cboSPONSORS to show relevant SPONSORS related to COUNTRY and CITY.
User Selects SPONSOR first, because they know the code.
• Filter cboCOUNTRY and cboCITY based on SPONSOR
Scenario A and Scenario B will result in a list of ACCOUNT TYPES specific to Country, City and Sponsor.
What is the best way to proceed to create a UserForm with this sort of multi-directional dependencies in Excel 2003?