You might want to check this out...
In Excel 2000 and higher there is a Calendar control on the Control Toolbar.
This shows a full calander.

Right click on the Controls Toolbox
Click Additional Tools
Select Calendar Control

Play with the Properties to get what you want.

(I haven't worked with this, yet)

--
sb
"bmwmcrider" wrote in message
om...
Hello,

I am trying to code a UserForm date entry technique using a TextBox
and a SpinButton but not having much luck at it. What I want to do is
have the date displayed in the text box as October 16, 2003. When I
hover over the month, it is hilighted and the spin button can be used
to select a new month. The same concept applies to the day and year
settings.

So my question is how is this done? I know that such a control exists
because is see done in Windows dialogs. In fact I have a couple apps
installed on my computer that popup dialogs and contain date setting
fields that do exactly as above.

I couldn't find anything on this subject in the couple Excel and VBA
books I have. Any help or suggestions would be appreciated. TIA ...

Mike