Here's something I use that may help get you started.
It'll likely require adding the Calendar Control to the toolbox in your vba editor.
In the vba editor, make sure the toolbox is showing and then go to
Tools > Additional Controls.
Scroll down and look for Calendar Control (in my case it's Calendar Control 11.0)
and click the checkbox for it & hit OK.
You should see a new control in the toolbox labeled 'MonthView'. Click it & draw it
onto the userform. (Make it's Visible property = False if you don't want it to show
all the time.)
You'll need a button or something on the userform to make it show.
(MonthView1.Visible = True)
Then in the userform's module you can add something like this:
Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
[A1].Value = Format(MonthView1, "mm/dd/yyyy")
If you get this far you'll probably be able to take it from here.
Check it out and post back after playing with it and getting a feel for it if you still
Another poster posted the use of the Calendar Control. I found out at my work location that most of the machines did not have this control installed on their 2002 machines which set me back a little bit since I was using my own home 2003 version which had it installed. Others stated they thought it was installed with Access but I don't know for sure if this is true one way or another.
In any case I went with DTPicker which is similar and was common to all the machines I have been dealing with.
Thought I would mention it as an alternative and a consideration to check into.