DTPicker

[pedie]

'm trying to insert this in userform but cant find DTPicker myself in controls....where is it located?
I show the sample from sample workbook i downloaded..


Thanks
Pedie

 

[VoG]

Hi Pedie

http://www.fontstuff.com/mailbag/qvba01.htm - the 2003 version works in at least Excel 2010.

 

[pedie]

Hi Pedie

http://www.fontstuff.com/mailbag/qvba01.htm - the 2003 version works in at least Excel 2010.

Hi Peter !

Thanks for helping!

 

[OfficeUser]

It is referred to as 'Calendar Control 10.0', perhaps your looking for the wrong control name.The 10 could be different based on your excel version.

 

[Norie]

pedie
You should find it if you right click the Control Toolbox and select Additional Controls...

 

[pedie]

Hi Officeuser, hi Norie... it tried following that navigation before i reached here..
and "'Calendar Control 10.0" is missing from the additional control listbox...maybe i'll have to download waht Peter refered me to...

 

[VoG]

Only available with versions of Office that include Access. Otherwise you need to download.

 

[pedie]

Only available with versions of Office that include Access. Otherwise you need to download.

I have access...except communicator
but cant find the control...but i'm still doing research...

I have calender control 12.0
but that is not what i actually want...
i'm wanting the calender to show only when the textbox or maybe combo box is clicked...and hide back once date is selected...


Thanks again..
Maybe it is different control on this kinda system..'ve Win Vista

 

[OfficeUser]

I was unaware of the control only being supplied if Access was installed. Thanks for that bit of knowledge.

 

[OfficeUser]

You should be able to use .Visible = True or False to accomplish that.