| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform - Entering Time
Is there a time picker like the date picker to help my users to enter time
into my userform? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Entering Time | Excel Discussion (Misc queries) | |||
| Entering military time into a userform | Excel Programming | |||
| Start A UserForm By Entering A Cell | Excel Programming | |||
| Entering Query Parameters by UserForm | Excel Programming | |||
| re-entering userform | Excel Programming | |||
Linear Mode
