Hello All,
Need help.
So I have a UserForm with 2 Listboxes - lstOldCity and lstNewCity.
lstOldCity - is populated based on the table tblCityListOld.
lstNewCity - is populated based on the table tblCityListNew.
Both tables are found on Sheet1.
As you can see, each city on the table has its corresponding number.
Basically, what I am trying to do here is search the list based on those numbers.
To identify on which list I am searching, I have 2 checkboxes which is CheckBox1 and CheckBox2.
CheckBox1 - will search on lstNewCity.
CheckBox2 - will search on lstOldCity.
When searching for lstOldCity, CheckBox2 is TRUE, user will enter a number on TextBox1.
After entering a number, the result or the city name will automatically come out on Label5.
When searching for lstNewCity, CheckBox1 is TRUE, user will enter a number on TextBox1.
After entering a number, the result or the city name will automatically come out on Label5.
Then on TextBox2, user will enter another number. The numbers are from 0 to 5.
These numbers has 2 results, Gender and Year of Birth.
0 - Male - 1900 to 1999
1 - Female - 1900 to 1999
2 - Male - 2000 to 2099
3 - Female - 2000 to 2099
4 - Male - 2100 to 2199
5 - Female - 2100 to 2199
Gender result will be displayed on Label6.
Year of Birth result will be displayed on Label7.
Notes:
• Edit: [I know its easier to just check on the list manually by scrolling, however,] the list of City on these examples are just some of the City I need. I will enter more once I settle the codes.
• Attached sample workbook.
Thank you again for the big help!