• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 28154
  • Last Modified:

Inserting Drop Down Date picker in Excel VBA Userform

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
Rrave26
Asked:
Rrave26
  • 2
  • 2
1 Solution
 
David LoInformation Technology ConsultantCommented:
1. Check out this tutorial:
http://www.fontstuff.com/excel/exltut03.htm

2. I would use a separate field to calculate durations.
0
 
Rrave26Author Commented:
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
 
David LoInformation Technology ConsultantCommented:
This page might make more sense to you.

http://www.fontstuff.com/vba/vbatut07.htm
0
 
Rrave26Author Commented:
Not ignoring you, I will take a look at that solution.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now