I know this has been done ad nausiam but can someone give me the code,
that
when a user clicks into a textbox the calender should pop up so as to
enter
the date? This will be done in the form and not in the worksheet

You can you a "date picker" control for this... go to your UserForm and
right-click the ToolBox, select "Additional Controls" and select "Microsoft
Date and Time Picker Control 6.0 (SP6)" from the list that appears. You can
place this control on your UserForm and it will allow the user to type the
date parts, use Tab and Arrow Keys to do change the date parts or to click
the down arrow and pick the date from a drop-down calendar.

Rick