Solved

Excel: Pop up Calendar and Clock

Posted on 2011-02-18
3
1,260 Views
Last Modified: 2012-05-11
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
0
Comment
Question by:NewToVBA
3 Comments
 
LVL 3

Accepted Solution

by:
byronwall earned 250 total points
ID: 34929695
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
 
LVL 5

Assisted Solution

by:wellous
wellous earned 250 total points
ID: 34932978
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
 

Author Closing Comment

by:NewToVBA
ID: 34946593
Well Done!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

838 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question