<div>
1. Check out this tutorial:<br />
<a href="http://www.fontstuff.com/excel/exltut03.htm" rel="ugc">http://www.fontstuff.com/excel/exltut03.htm</a><br />
<br />
2. I would use a separate field to calculate durations.
</div>


1. Check out this tutorial:
http://www.fontstuff.com/excel/exltut03.htm [http://www.fontstuff.com/excel/exltut03.htm]

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

<div>
This article seems to apply to putting a drop down calendar on an excel spreadsheet. &nbsp;Will this work if I want the calendar to pop up on the userform I've created?
</div>


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?

<div>
Not ignoring you, I will take a look at that solution.
</div>


Not ignoring you, I will take a look at that solution.

<div>
<div class="content wysiwyg-content">
I have a user form for entering several date and time information. &nbsp;For ease of data entry I'd like to utilize the date and time picker in Excel 2010. &nbsp;I want the user to click on a &quot;Date&quot; &nbsp;button in field A and have the date picker pop up and they can select the date and have it populate field A. &nbsp;Then they would move to the next fiield click on the &quot;Date&quot; button and they can select the date and have it populate filed B. &nbsp;Here are my questions:<br />
<br />
1. &nbsp;What is the best way to accomplish this?<br />
2. Since I will be calculating durations is it best to enter the date and time in one field or do it seperate fields. &nbsp;<br />
<br />
Hope this helps.
</div>
</div>


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.

Inserting Drop Down Date picker in Excel VBA Userform

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.