DropDown Calendar

Dear - Too Confusing, lets make it easy.
Click on the sheet you want the DTPicker on. Click on the Developer Tab. Click on Insert Icon. Click the More Controls Icon. Now for the hard part.
Find Microsoft Date Time Picker in that long list and click on it. This makes your mouse cursor change and you drag a rectangel on your sheet where you want to place the picker control.

Now it is on your sheet but what the heck do you do with it?

Click on the View Basic and couble click on the sheet that you just dropped the DTPicker on. There are two dropdown boxes at the top of the code window. Drop the left one down and change it from WorkSheet to DTPicker1. Dropdown the box just to the right of it and select Change.

Now you have a Private Sub for DTPicker1. I did a little code that puts the date selected in A1 (I know this as Cell(1,1)

Find the example and play with it until it makes sense. This is an easier way to show a calendar than the old way.

hope this example gets you through the "first time" problem.