Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can I view all the data in a cell? | Excel Discussion (Misc queries) | |||
Data Validation Cell - Move to UserForm | Excel Worksheet Functions | |||
View Row Data in UserForm / Edit | Excel Programming | |||
UserForm with Cell Data | Excel Programming | |||
Taking Data of cell from worksheet to a userform window | Excel Programming |