Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform to have Last Updated Values Time & Date Displayed ??
I have a Userform that displays several values, and asks for an update of
the values. The user may update them or leave them blank for No Changes to the Values. What i want to do is place a comment or Label that displays on the userform, the previous time and date the values(at least 1) was modified/updated. How can i do this? Do i add a Label or a Text Box ? And how would i code that to suit this? Corey.... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform to have Last Updated Values Time & Date Displayed ??
Currently i do not store any times/dates for the running or modifying of
this u/form or values on it. How do i set that up 1st? Corey.... "Alok" wrote in message ... Hi Corey Do you store the time when the value was changed last? Where. In any case since this value is to be shown only as a comment it is better to use a label rather than a text box. You can also use a ControlTipText property rather than a text box or a label. Alok "Corey" wrote: I have a Userform that displays several values, and asks for an update of the values. The user may update them or leave them blank for No Changes to the Values. What i want to do is place a comment or Label that displays on the userform, the previous time and date the values(at least 1) was modified/updated. How can i do this? Do i add a Label or a Text Box ? And how would i code that to suit this? Corey.... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform to have Last Updated Values Time & Date Displayed ??
In your data work sheet add a column/cell for last updated and set the
default to say 1/1/1990. Then you add a label to the user form and set the label to the last updated value. you need to do this in the userform_initialize event eg datelastupdated=worksheets("sheet1").range("A1") 'cell where last update is if datelastupdated < #01/01/1990# then me.labellastupdate="Last updated: at " & format( _ datelastupdated , "Hh:Nn ""on"" dd/mm/yyyy") end if unless the form is bound to data in which case you need to bind the label to the data (not sure if that is possible, may need a text box in that case (but can set it to fixed)). -- Hope this helps Martin Fishlock Please do not forget to rate this reply. "Corey" wrote: Currently i do not store any times/dates for the running or modifying of this u/form or values on it. How do i set that up 1st? Corey.... "Alok" wrote in message ... Hi Corey Do you store the time when the value was changed last? Where. In any case since this value is to be shown only as a comment it is better to use a label rather than a text box. You can also use a ControlTipText property rather than a text box or a label. Alok "Corey" wrote: I have a Userform that displays several values, and asks for an update of the values. The user may update them or leave them blank for No Changes to the Values. What i want to do is place a comment or Label that displays on the userform, the previous time and date the values(at least 1) was modified/updated. How can i do this? Do i add a Label or a Text Box ? And how would i code that to suit this? Corey.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
updated cell with current time\date if any data in a row has chan | Excel Worksheet Functions | |||
date and time updated automatically | Excel Worksheet Functions | |||
Current date and time updated automatically | Excel Discussion (Misc queries) | |||
How to have:= NOW () date/time change only if updated and saved | Excel Worksheet Functions | |||
Userform and passing date values | Excel Programming |