ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Control to pick time? (https://www.excelbanter.com/excel-programming/440487-control-pick-time.html)

Robert Crandal

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



Skiffle

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


Robert Crandal

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



Skiffle

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



All times are GMT +1. The time now is 10:31 AM.

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