Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 309
Default Control to pick time?

Are there any options or controls which allow someone
to easily select a time? The DTPicker control seems
to be heavily designed for choosing dates, and I'd like
something that might display a clock or something.

Thank you


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Control to pick time?


"Robert Crandal" wrote in message
...
Are there any options or controls which allow someone
to easily select a time? The DTPicker control seems
to be heavily designed for choosing dates, and I'd like
something that might display a clock or something.

Thank you


Robert,

The DTPicker should have a format property called dtpTime.

In design mode, select the DTPicker, right click -- Properties -- Format.
What options do you see ?

Skiffle

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 309
Default Control to pick time?

Yes, I have seen that option, but I was hoping for something
better. The time option only has drop down arrows to
scroll hours, minutes, or seconds, but the date option gives
you a nice big graphical calendar.

I was just wondering if there were any other alternatives
out there????

thank you Skiffle!


"Skiffle" wrote in message
...

Robert,

The DTPicker should have a format property called dtpTime.

In design mode, select the DTPicker, right click -- Properties --
Format. What options do you see ?

Skiffle


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Control to pick time?


"Robert Crandal" wrote in message
...
Yes, I have seen that option, but I was hoping for something
better. The time option only has drop down arrows to
scroll hours, minutes, or seconds, but the date option gives
you a nice big graphical calendar.

I was just wondering if there were any other alternatives
out there????

thank you Skiffle!


"Skiffle" wrote in message
...

Robert,

The DTPicker should have a format property called dtpTime.

In design mode, select the DTPicker, right click -- Properties --
Format. What options do you see ?

Skiffle


Robert,

The only options I can think for time is analog or digital.

From what I can think of, your options a
1. "Big graphical" analog watch
2. Digital clock (like the dtpTime option)

Hopefully you can find a custom format (size, color, time format hh:mm) that
suits your needs. Maybe Google or Bing will provide more options ? Good
luck.

Skiffle

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
Pick time from cell Kash Excel Programming 2 June 29th 09 11:21 PM
Need a control to pick worksheet cell ranges keith Excel Programming 2 April 12th 09 02:53 AM
How to get buttons on floating control to pick up colour Roger Govier Excel Programming 4 December 4th 06 03:41 PM
How to control "Date Time Picker ActiveX Control" Jafery Excel Programming 1 July 21st 05 02:38 PM
auto pick date & time as i enter name help me auto pick date & time as i enter name Excel Programming 5 January 13th 04 01:45 PM


All times are GMT +1. The time now is 05:23 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"