Excel: Pop up Calendar and Clock

Hi,
Variation in data manually entered into an Excel file causes defects and is time consuming. I am looking for a code that can pop up a window with
calendar and numeric clock where a user can click and choose values which then will be entered into a cell selected by cursor,  in a format "mm/d/yy h:mm AM/PM;@".
I found this link http://www.fontstuff.com/vba/vbatut07.htm with a calendar solution, but could not find both as one utility.

Tks, N
NewToVBAAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
byronwallConnect With a Mentor Commented:
You can make use of the "Microsoft Date and Time Control" using a custom format of "MM/dd/yyyy HH:mm".  This could be employed with several different methods.  It will give you a drop down calendar for selecting the data and the time fields for entry as well.

See the attached workbook which has the popup activate on CTRL SHIFT Q.

 date-pop-up.xlsm
0
 
wellousConnect With a Mentor Commented:
Hi,

Yes , you can do it with date /time as per my attachment ...
Click on cell B2 and tell me if you like it.
Cheers,

Wellous
date-timepickerver1-1-.xls
0
 
NewToVBAAuthor Commented:
Well Done!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.