Solved

Inserting Drop Down Date picker in Excel VBA Userform

Posted on 2013-11-26
4
22,292 Views
Last Modified: 2014-01-06
I have a user form for entering several date and time information.  For ease of data entry I'd like to utilize the date and time picker in Excel 2010.  I want the user to click on a "Date"  button in field A and have the date picker pop up and they can select the date and have it populate field A.  Then they would move to the next fiield click on the "Date" button and they can select the date and have it populate filed B.  Here are my questions:

1.  What is the best way to accomplish this?
2. Since I will be calculating durations is it best to enter the date and time in one field or do it seperate fields.  

Hope this helps.
0
Comment
Question by:Rrave26
  • 2
  • 2
4 Comments
 
LVL 2

Expert Comment

by:David Lo
Comment Utility
1. Check out this tutorial:
http://www.fontstuff.com/excel/exltut03.htm

2. I would use a separate field to calculate durations.
0
 

Author Comment

by:Rrave26
Comment Utility
This article seems to apply to putting a drop down calendar on an excel spreadsheet.  Will this work if I want the calendar to pop up on the userform I've created?
0
 
LVL 2

Accepted Solution

by:
David Lo earned 500 total points
Comment Utility
This page might make more sense to you.

http://www.fontstuff.com/vba/vbatut07.htm
0
 

Author Comment

by:Rrave26
Comment Utility
Not ignoring you, I will take a look at that solution.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
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.

762 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now