Posted to microsoft.public.excel.programming

Patrick C. Simonds Patrick C. Simonds is offline

external usenet poster

Posts: 343

Time in a TextBox

I would like the code below to put the current time (in 24 hour format) in
TextBox3. So how can I modify this so I only get the time and not the date
and have the displayed time in the 24 hour format (18:45 for 6:45pm)

Private Sub TextBox1_Change()
TextBox3.Value = Now()
End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Time in a TextBox	Patrick Molloy	Excel Programming	0	July 2nd 09 04:54 PM
TextBox to time	Patrick C. Simonds	Excel Programming	7	January 14th 09 09:19 PM
Textbox for accepting TIME	WLMPilot	Excel Programming	16	January 8th 08 06:58 PM
How do I format a textbox with time	Jennifer	Excel Programming	1	July 13th 06 06:27 AM
TextBox and Time	Soniya[_4_]	Excel Programming	2	December 3rd 05 07:17 AM

All times are GMT +1. The time now is 08:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us