creating data validation list from vba & display the dependent description in msgbox

[svibuk]

i have Countrylist in column X and its capital in column Y . the country & city list is populated in the sheet from database

i am creating a data validation list dropdown in cell K9

Please Login or Register  to view this content.

wht i need is whtever data item is selected from the list its corresponding capital shld be displayed in mgsbox
i need it from VBA

[protonLeah]

The better alternative is to create a dynamic named range, "CountryList" for the country list using:

Please Login or Register  to view this content.

Name the cell K9 "CountryPick"

Then your VB code would just be a sheet change event that checks if X9 changes and pops the msgbox:

Please Login or Register  to view this content.