View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default 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