title: Excel : Input and Retrieve Data using Textbox
body: <p>I have a listBox with different countries name, 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 containing the countries and comments columns.</p>
  
  <pre><code>=VLOOKUP(INDEX(countries,$C$10),countriestable,2,FALSE)
  </code></pre>
  
  <p>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 textbox and this will be saved in the countriestable accordingly (As per country selected )</p>
  
  <p>The problem is I could link the texbox2 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 countrie from the listbox, the values in Textbox2 logically will noo change ( static ).</p>
  
  <p><strong>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 ?</strong></p>
  
  <p>Thanks for any guidance,
  Regards</p>
  
  <p>Excel version 2007</p>