I need to search for a country name in an excel file and assing those values for multiple textboxes. For example:
Afghanistan | +4 | AF | Kabul.
When the user searches for the country name, the form will display the timezone (+4), Country Code (AF), the name (Afghanistan) and the capital city (Kabul) in 4 different textboxes.
What I have tried:
So far I managed to find the location of the searched country, so if the user searches for "Afghanistan" I can locate the position (column A, row 1), but I have no clue about how to read that value and the rows next to it to assign it to the multiple textboxes