title: vba excel View cell but keep formula intact
body: <p>I am using vba with excel to make a user interface what I have is 7 text boxes 6 of the grab the cells m10 - m16 and allow the user to change m17 does exactly the same but my problem is I want to only view m17 and keep the formula everytime I run the program and change a value use 1 of the other 6 boxes it changes the value but removes my formula how can I make it view the result but keep my formula</p>
  
  <pre><code>Private Sub nnn()
  
  End Sub
  
  Public Sub Frame1_Click()
  
  End Sub
  
  Private Sub Label12_Click()
  
  End Sub
  
  Private Sub Label13_Click()
  
  End Sub
  
  Private Sub Label5_Click()
  
  End Sub
  
  Private Sub Label6_Click()
  
  End Sub
  
  Private Sub TextBox12_Change()
  
  End Sub
  
  Private Sub TextBox3_Change()
  
  End Sub
  
  Private Sub TextBox15_Change()
  
  End Sub
  
  Private Sub UserForm_Click()
  
  End Sub
  
  Private Sub UserForm_Initialize()
  TextBox15.Text = ThisWorkbook.Sheets("Sheet1").Range("F10").Value
  End Sub
  </code></pre>
  
  <p>this is my code but I do not assign the cell in this cod I assign it to text_box4 by right clicking it in the visual editor within excel view properties and enter in as a controlsource</p>