Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time in a TextBox
Private Sub TextBox1_Change() TextBox3.Value =format$( Now(),"HH:MM") End Sub "Patrick C. Simonds" wrote in message ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TextBox to time | Excel Programming | |||
Textbox for accepting TIME | Excel Programming | |||
How do I format a textbox with time | Excel Programming | |||
TextBox and Time | Excel Programming | |||
Format As TIME In A TextBox | Excel Programming |