ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   View the data in a cell on a userform (https://www.excelbanter.com/excel-programming/287302-re-view-data-cell-userform.html)

Henry[_5_]

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





All times are GMT +1. The time now is 12:12 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com