User form and date

[Aviad]

Hi,

How can i enable my user to go into user form and choose a specific day from a calender ?

i allready have the user form i just cant find the calender in order to deploy it in the from.

Thanks,
Aviad

 

[Trevor G]

Depending on the version you are using?

First of all look at the vb screen then select your form in design view, on the controls toolbar look to add a control then search for the Microsoft Calendar this will add a calendar to the form.

 

[Aviad]

i'm using 2010

 

[Trevor G]

As your using 2010 you can add the Date Picker which gives you a drop down and you can select the date.

As per previous reply, go into your VBA screen then select the form, in the controls toolbox use the right mouse button and select to add controls, then scroll down the list until you come across the date picker, add a tick in the box to the left then click ok. On the control toolbox you will then have an extra icon, drag it into your form, size as necessary, test the form and you will get a date picker.

 

[Aviad]

OK. what's the name of the date piker .. i cant see it.. i have a long list can you specify the name of it ?

Thanks a lot!!

Aviad

 

[Trevor G]

Scroll down the controls until you find

Microsoft Date and Time Picker Control 6.0 [SP4]

 

[Aviad]

Thanks!

But i get the massage after draging it to the form: "Elemebt bot found" i think its a local problem with the ffice installation..

Do you think i can be something else ?

Aviad

 

[Trevor G]

Can you look to download the control and add it from Microsoft?

Check out this link

http://danielcurran.com/instructions/how-to-install-microsoft-date-time-picker-control-60-sp4/

You can search the net use for

Microsoft Date and Time Picker Control 6.0 [SP4]