Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sue Sue is offline
external usenet poster
 
Posts: 285
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
'spin buttons' & vbasic language Browny Excel Discussion (Misc queries) 0 May 9th 08 04:27 AM
Text boxes and Spin buttons JT Excel Programming 1 August 9th 07 02:46 PM
Spin Buttons are too Slow For Use [email protected] Excel Discussion (Misc queries) 2 June 19th 07 05:16 PM
Activate Spin Buttons with Keys Donny[_3_] Excel Programming 1 August 22nd 06 06:43 AM
How can I use the Spin or Toggle buttons to change cell values PKyle Excel Programming 1 April 7th 04 10:39 PM


All times are GMT +1. The time now is 07:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"