VBA Forms- text box calculation

[daveys]

Hi,

I have been struggling with a userform, I need to be able to display an active componet when a text box value has been changed. Here is what I have done so far.

Private Sub corn1_change()
UserForm2.VitMin1.Text = Sheets("input output metric").Range("Q27").Value
End Sub

The problem with this code is when I change the values in the demonstarted textbox (corn1) it is always a step behind ie updates the previous number.

Is there a better way of doing this, I am very new to forms (this is my first)

What I am trying to achieve is when a value is entered into a textbox it updates the spreadsheet (i have this sorted) and then the value in another box (VitMin1) changes based on another cell "Q27".

Thanks