title: I want to write to a Vlookup statement
body: <p>I want to write to a Vlookup statement. I'm populating text boxes in a VBA form with a series of:</p>
  
  <p>With frmDragonInfo</p>
  
  <pre><code>.txtInfo6 = Application.Text(WorksheetFunction.VLookup(DrLevel + 1, Range(DrCode), 2), "[hh]:mm")
  </code></pre>
  
  <p>Then, having updated the text boxes, I want to click a cmd button on the form write it back again with:</p>
  
  <p>With Sheets("DataList")</p>
  
  <pre><code>Application.WorksheetFunction.VLookup(DrLevel, Range(DrCode), 2) = txtInfo1.Text
  </code></pre>
  
  <p>DrLevel is a number from 1 to 100 &amp; DrCode is a named range on the 'DataList' sheet.
  That doesn't work. Can I write to a Vlookup? if so, How? Thanks.</p>