ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Spin Buttons For Time? (https://www.excelbanter.com/excel-programming/413945-spin-buttons-time.html)

Sue

Spin Buttons For Time?
 
Hi All

I have a UserForm with 3 textboxes namely -- Hours / Minutes / Seconds is it
possible to have a spin button for moving the time Hours / Minutes / Seconds
up or down.
I know how to do it with the date but no idea at all with time.
--
Many Thanks

Sue

Nigel[_2_]

Spin Buttons For Time?
 
Same as dates, except use the Hour, Minute, Second, Timeserial, TimeValue
functions, not Day,Month,Year



--

Regards,
Nigel




"Sue" wrote in message
...
Hi All

I have a UserForm with 3 textboxes namely -- Hours / Minutes / Seconds is
it
possible to have a spin button for moving the time Hours / Minutes /
Seconds
up or down.
I know how to do it with the date but no idea at all with time.
--
Many Thanks

Sue




All times are GMT +1. The time now is 08:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com