Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time in a TextBox
Thank you sir "Patrick Molloy" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Time in a TextBox
There is also a Time function in VB, but you would still need to use the Format function to get 24-hour time (unless your computer's local setting for time is already formatted as 24-hour time)... TextBox3.Value = Format$(Time, "hh:mm") Note that I did not use Time() for the function call as the parentheses on a function call are not needed when they contain no arguments between them. So, your Now() function call would also work just as well if you used Now instead (this is different than function calls in formulas on the worksheet itself where the parentheses are always needed). -- Rick (MVP - Excel) "Patrick Molloy" wrote in message ... 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 | |||
Time in a TextBox | Excel Programming | |||
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 |