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