Inserting Time in a cell

[austenr]

I know that there is a pop up calendar, but is there a way for a user to pick a time to enter similar to the pop up calendar? Thanks

[MOS MASTER]

Hi,

Well yes there is. You talk about a calendar control. There are several but some of them you can use as a time picker.

DTPicker is one of them. (Microsoft Date & Time Picker control 6.0 (SP 4))
The Ocx that you need on your machine is: mscomctl2.ocx

You can set the custom properties so only time is shown.
You just select that bit of time you wish to change and use the toggle button to change it.

Included a simple sample for you.

[sheeeng]

Just in case you want to enter static data/time stamp without calender control...

If you want to enter a static date stamp on a cell, press Ctrl + ;
If you want to enter a static time stamp on a cell, press Ctrl + Shift + ;

HTH.

[MOS MASTER]

Austen,

Did it work out with the DTPicker?

[sheeeng]

Austen,

Did it work out with the DTPicker?

I tried it, Joost.
Nice code.

[MOS MASTER]

I tried it, Joost.
Nice code.

Glad you liked it..let's hope it solves Austens query.

[austenr]

Yes that is what I needed. Great!! Thanks

[MOS MASTER]

Yes that is what I needed. Great!! Thanks

You're welcome! (don't forget to mark the thread)

[sheeeng]

Yes that is what I needed. Great!! Thanks

Hi austenr,
Please mark your thread solved by clicking Solved by hitting the Thread Tools dropdown at the top of the thread. (If you happy with all the help given)

[Cyberdude]

Just in case you want to enter static data/time stamp without calender control...

If you want to enter a static date stamp on a cell, press Ctrl + ;
If you want to enter a static time stamp on a cell, press Ctrl + Shift + ;

HTH.

Hey, Sheeeng, maybe you typed something other than the plus sign, but on my computer I have to use the colon, not the "+" to get the date and/or time.

[sheeeng]

Hey, Sheeeng, maybe you typed something other than the plus sign, but on my computer I have to use the colon, not the "+" to get the date and/or time.

Sorry, What I mean is the "+" meaning "press together".
Sorry for the misleading suggestions.

[Cyberdude]

No problem, sheeeng, I was pretty sure you didn't mean the "+", but you never know. Have a nice day!

[sheeeng]

No problem, sheeeng, I was pretty sure you didn't mean the "+", but you never know. Have a nice day!

Thank you for clarify everything....
If not, I'll be misleading the readers of this thread....