VBA application to manipulate CSV file

Your application is expected to perform the following tasks: ● Read the [login to view URL] file that attached ● Display a list of all the countries in the CSV file. Keep in mind that each country will have around 6 observations (records). So make sure no country is repeated in the country list. ● Display the overall average, min, and max values of population, internet users, and life expectancy. ● If user selects a country, then display the following information: ● List of years of observations available ● Average, min and max values of population, internet users, and life expectancy for that specific country. ● Year with highest population, internet users, and life expectancy ● Year with lowest population, internet users and life expectancy ● Population, internet users, and life expectancy for that specific year. ● If user selects a year within a country, then display the following information: ● For the currently selected country, user should be able to store a report on file. The file should be a simple text file that is human readable. It should include the following information: ● Overall averages, min, and max for all countries ● Country average, min, and max across the years ● Observations for that country for all the years we have on file. ● File name should be [login to view URL], where xxx is replaced by country name. ● The file should be easy to read by humans and will be mainly used to do value comparisons, so organize it as best you can for that. ● User should be able to search for country name. User must enter at least 3 letters for search to work, and should list only the countries that include the letters in the search box. Search must be case insensitive. ● Keep in mind, the design and layout of the application screen is part of the evaluation. Make sure the application is easy to use and is clear. Feel free to discover new controls and use them if you think they are better than what we learned in class. This will earn you bonus and make your application look better.