Use a Calendar to Autofill Date in Form

[StevieF8]

I have a form in design veiw Userform3 and a Calendar created in Userform4

I want the user to select a box and the calendar to automatically pop up,
the date to be selected, the calendar to close and the date to be autofilled into the box

Can someone give me any idea how to do this - the code would be brilliant

Thanks in advance

Ste

[davesexcel]

I have a form in design veiw Userform3 and a Calendar created in Userform4

I want the user to select a box and the calendar to automatically pop up,
the date to be selected, the calendar to close and the date to be autofilled into the box

Can someone give me any idea how to do this - the code would be brilliant

Thanks in advance

Ste

did you try the click event???
If you have gotten this far you must know how to select events in the right drop down menu..........

[StevieF8]

did you try the click event???
If you have gotten this far you must know how to select events in the right drop down menu..........

I am working in Excel - can't seem to find click event?

[davesexcel]

I have a form in design veiw Userform3 and a Calendar created in Userform4

I want the user to select a box and the calendar to automatically pop up,
the date to be selected, the calendar to close and the date to be autofilled into the box

Can someone give me any idea how to do this - the code would be brilliant

Thanks in advance

Ste

There is a calender control you could use in the UserForm1, it's called date picker
when you click on the userform and the controls toolbox shows, right click on the tool box and select add controls, find microsoft date picker and check the box beside it, then OK,
the control will now be on the tool box,