title: Can a text box in a UserForm contain formula?
body: <p>I have had a look online for an answer to this but no joy with coming across one as of yet. Is it possible to have a text box in a UserForm be dynamic? </p>
  
  <p>My current idea is to have 3 columns of text boxes, in Column 1 &amp; 2 the user need to enter there data and was wondering if in Column 3 there is a way to show the value involving Column 1 and Column 2? </p>
  
  <p>If this isn't possible, are you able to reference a cell on a sheet and then get the useform to display the cells value? </p>
  
  <p>Ideally i would like this to be possible as it provides the user with a quick check to ensure they've entered the data right. </p>
  
  <p><strong>Edit 1</strong></p>
  
  <p><code>TextBox18.Value = (TextBox1.Value + TextBox10.Value) / 2</code>
  I found that this line of code allowed me to reference two text boxes dynamically but textbox 18 concatenating rather than added the numbers. Is there a way round this? </p>
  
  <p>Thanks  </p>