Date Picker code

[cfer]

Hi,

I have a user form with a Date Picker and a text box.

When the user form shows, the date picker also shows on the user form, when I click a date, the date is transferred to the text box.

What I would like is to have a command button when clicked, displays the date picker, pops up
When the user clicks on the date, it will automatically do the following
pass the date to the text box, then
close the date picker

I have researched but cannot find any code that will allow met to do this

Thanks in advance.

 

[mumps]

Click here to download a sample file. Run the macro in Module1 to display the userform.

 

[cfer]

Hi mumps,

Thank you very much, it worked like a charm.

Cfer

 

[mumps]

You are very welcome.