?
Solved

Excel: Pop up Calendar and Clock

Posted on 2011-02-18
3
Medium Priority
?
1,535 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 1000 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 1000 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

Enroll in October's Free Course of the Month

Do you work with and analyze data? Enroll in October's Course of the Month for 7+ hours of SQL training, allowing you to quickly and efficiently store or retrieve data. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
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.

649 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