Solved

Excel: Pop up Calendar and Clock

Posted on 2011-02-18
3
1,291 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

749 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