View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Corey Corey is offline
external usenet poster
 
Posts: 24
Default 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....