Re: Inserting Date into TextBox
From: Bob Phillips (bob.phillips_at_notheretiscali.co.uk)
Date: 06/12/04
- Next message: Rob van Gelder: "Re: blinking cell?"
- Previous message: Bob Phillips: "Re: Deleting a textbox control at runtime"
- In reply to: scottnshelly: "Re: Inserting Date into TextBox"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 12 Jun 2004 10:22:35 +0100
Depends what you mean by real time. It would be easy to have the textbox
updated upon a certain event as long as the form is still up, just a simple
With MAINFORM
.DateTextBox.Text = Format(Date,"dd-mm-yy hh:mm:ss")
End With
If you want the textbox ticking over each second, then that is much more
complex. You would need a timer. You could use OnTime, but I would
personally use the Windows timer, and have a callback to manage the updates.
I could knock you up a sample workbook if you are interested, and you give
me your email address.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"scottnshelly >" <<scottnshelly.17pv98@excelforum-nospam.com> wrote in
message news:scottnshelly.17pv98@excelforum-nospam.com...
> Can we add the time to this to update in real-time?
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
- Next message: Rob van Gelder: "Re: blinking cell?"
- Previous message: Bob Phillips: "Re: Deleting a textbox control at runtime"
- In reply to: scottnshelly: "Re: Inserting Date into TextBox"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
