DTPicker Object

[mikeymay]

Is it possible to display a DTPicker on a user form and show as blank until a user has selected a date?

Also, I would like the format of any selected date to be show as 'dd mmm yy' rather than any of the options available in the object properties.


Thanks

 

[diddi]

yes there is one built in to excel, but hidden. goto Tools>Additional controls

scroll throught the list to Microsoft Date and Time Picker Control and check the checkbox, then OK


you will have a new control to stick onto a userform

 

[mikeymay]

Thanks diddi

Is this embedded in the file when selected as the file is to be used by lots of users?


Thanks

 

[mikeymay]

Hmmmm.....I already had this selected.

I have got this selected so I can use the Date & Time Picker (DTPicker in my toolbox) rather than using the Calander.

 

[diddi]

not sure about that. you may need to reference another library.

 

[diddi]

my one is v6.0 and it works in xl2003