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.
You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents. The steps to find the Templates folder path are …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.