User Input using a Calendar

[MichaelA]

Hello All,

Does anyone know if it is possible to take user input for a date using
a calendar using VBA?

Thank you in advance.


Michael A.

 

[Hans]

Yes, this is definitely possible.
You need to use the DateTimePicker (DTPicker) control for this.
Add following control to your toolbox to use it:
Microsoft Date and Time Picker Control 6.0

I hope this helps,
Hans



Projectopolis



MichaelA wrote:

Hello All, Does anyone know if it is possible to take user input for a date using a calendar using VBA? Thank you in advance. Michael A.

 

[Jack Dahlgren]

Yes. Create a user form and add the control, then have the control set the
date.
First you need to add the control to your toolbox. Open your user form, then
right click on the toolbox and select "Additional Controls". Scroll down and
check the Microsoft Date and Time picker.

I've had issues with this control in the past when different users had
different builds of their operating system and did not have the control
available on their machine so definitely test across the organization before
you deploy.

-Jack Dahlgren