I have a listBox with different country names, when a country is selected information related to this country will show up in a textbox. I did that using a simple VLOOKUP for a table ( On different Sheet/Hidden ) containing the countries and Comments columns.

=VLOOKUP(INDEX(countries,$C$10),countriestable,2,FALSE)


Now let's say I would like to add a Second TextBox, which will have a reverse action, user will input data/Comments in the textbox2 and this will be saved in the countriestable accordingly (As per country selected / Index number )

The problem is I could link the textbox2 to a cell and add the same formula as textbox1, but then when I input data, it will overwrite the linked-cell formula, then when I change country from the listbox, the values in Textbox2 logically will not change ( static comment). I want a interactive way where a user can read Comment and Update the Comment for this country.

How can I achieve a way where ( On same page ) I have a texbox to display data from the table ( Step1 is succesfull ) and a Texbox in which a user can write/input comment data ?

Thanks for any guidance, Regards

Excel version 2007