How to set Time Picker in excel user form to 24 hrs format?

[cyrous0425]

I tried the custom format and enter HHmm custom but when I run the macro after hitting the arrow it will displayed the date instead?


Thanks

 

[Domenic]

You'll need to set the Format property to dtpCustom, and then you can set the CustomFormat property to "HHmm". If you want to set these properties by code, assuming that the date and time picker control is named DTPicker1, try...

    With Me.DTPicker1
        .Format = dtpCustom
        .CustomFormat = "HHmm"
    End With

Hope this helps!

 

[John_w]

dtpCustom will always display the calendar when the arrow is clicked, regardless of CustomFormat.

To get time only, set the Format property to dtpTime. Unfortunately, CustomFormat seems to be ignored and its format is always HH:mm:ss.

 

[cyrous0425]

I tried the dtpCustom but when I enter time on the time picker it becomes 0000. ​Same result with the code above.

 

[Domenic]

With dtpCustom, you can't select a time from the drop down menu. You can only select a date. So you would have to either tab to the date and time picker or click the first two digits so that the first two digits of the time are selected, and then you change the time. As an example, with the first two digits selected, you can either type 8:30 or first type 8, and then right-arrow to the next two digits to enter 30.