Userform - Entering Time
 

Is there a time picker like the date picker to help my users to enter time
into my userform?

Userform - Entering Time
 

Not really. How should that work ? Click-a-clock ? It's possible to build a
thing like that.

HTH. Best wishes Harald


"TEB2" skrev i melding
...
Is there a time picker like the date picker to help my users to enter time
into my userform?

Userform - Entering Time
 

No.

What would a time picker display. Hours? Minutes? Seconds?

--
Regards,
Tom Ogilvy

"TEB2" wrote in message
...
Is there a time picker like the date picker to help my users to enter time
into my userform?

Userform - Entering Time
 

You can use the DateTimePicker to do this. Drop the control on to
a userform, press F4 to display the Properties window, click
Custom, and change the Format property to dpTime.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TEB2" wrote in message
...
Is there a time picker like the date picker to help my users to
enter time
into my userform?

Userform - Entering Time
 

Just curious, so what does that display. Dropdowns for hours, minutes,
seconds?

--
Regards,
Tom Ogilvy


"Chip Pearson" wrote in message
...
You can use the DateTimePicker to do this. Drop the control on to
a userform, press F4 to display the Properties window, click
Custom, and change the Format property to dpTime.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TEB2" wrote in message
...
Is there a time picker like the date picker to help my users to
enter time
into my userform?

Userform - Entering Time
 

No, it displays the time in hh:mm:ss format, and the spinner
button on the right side of the controls spins the selected time
component up or down. No clock face or anything like that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tom Ogilvy" wrote in message
...
Just curious, so what does that display. Dropdowns for hours,
minutes,
seconds?

--
Regards,
Tom Ogilvy


"Chip Pearson" wrote in message
...
You can use the DateTimePicker to do this. Drop the control on
to
a userform, press F4 to display the Properties window, click
Custom, and change the Format property to dpTime.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TEB2" wrote in message
...
Is there a time picker like the date picker to help my users
to
enter time
into my userform?

Userform - Entering Time
 

Thanks.

--
Regards,
Tom Ogilvy

"Chip Pearson" wrote in message
...
No, it displays the time in hh:mm:ss format, and the spinner
button on the right side of the controls spins the selected time
component up or down. No clock face or anything like that.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Tom Ogilvy" wrote in message
...
Just curious, so what does that display. Dropdowns for hours,
minutes,
seconds?

--
Regards,
Tom Ogilvy


"Chip Pearson" wrote in message
...
You can use the DateTimePicker to do this. Drop the control on
to
a userform, press F4 to display the Properties window, click
Custom, and change the Format property to dpTime.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"TEB2" wrote in message
...
Is there a time picker like the date picker to help my users
to
enter time
into my userform?