Problem:
In my situation, there are a large number of users (500+) who have each given up to four options for states/countries they want to represent in a tournament. My first column is the usernames, and the next four are the options they gave for countries as seen here:
After the first option, the following ones are optional. There are 13 teams in this tournament that represent areas of the world, such as Asia, Canada, and US Central. Multiple states/countries are included in each region, such as for Canada, only Canada will make someone eligible for Canada. However, for US Central, states like Texas, Oklahoma, and Kansas all are included; or Asia, countries like India and China are included. I have created a userform with a listbox containing all the teams, and when a team is selected, I need a message box to pop up containing all the players who can possibly play in that region based on the states/countries they listed in their four options. I need a way to make each row an array or other variable that can be searched to see if that row(user) is eligible to play in the selected team.
In my situation, there are a large number of users (500+) who have each given up to four options for states/countries they want to represent in a tournament. My first column is the usernames, and the next four are the options they gave for countries as seen here:
After the first option, the following ones are optional. There are 13 teams in this tournament that represent areas of the world, such as Asia, Canada, and US Central. Multiple states/countries are included in each region, such as for Canada, only Canada will make someone eligible for Canada. However, for US Central, states like Texas, Oklahoma, and Kansas all are included; or Asia, countries like India and China are included. I have created a userform with a listbox containing all the teams, and when a team is selected, I need a message box to pop up containing all the players who can possibly play in that region based on the states/countries they listed in their four options. I need a way to make each row an array or other variable that can be searched to see if that row(user) is eligible to play in the selected team.