View the data in a cell on a userform
Andy,
By last entered value, do you mean the current value (after the update) or
the previous value?
If you want the current value of the cell:
Assuming your data is in Cell A1 on sheet1 and you want it in TextBox1 then
TextBox1.Text = Sheets("Sheet1").Range("A1").Value
If you want the previous value you will have to put the new value somewhere
else (so it doesn't overwrite the old value)
Use the above line of code.
When you no longer need the old value, overwrite it with the new value.(cut
and paste)
HTH
Henry
"ANdy Bolton" wrote in message
...
I am using a userform for users to enter exchange rate
information which then populates an exchange rate
worksheet, however I would like to view the last entered
value either on a separate userform or on the same one in
some way. How do I go about this.
Kind regards
Andy Bolton
|