DTPicker ver 6.0 sp4 TURN TIME OFF

[mmikem]

Hi Everyone
Does any one know how to turn the time feature on DTPicker 6 off
I just need day month year the time is changing the format on me
I use the DTPicker on a user form but on my work sheet I have it to format the date as 12-jan-19

Thanks Mike

Ps Does any one have a idea about Run time error please see my last post for details

[Keebellah]

First I try to always avoid a datepicker due to compatibility issues, but that's a personal choice.
As far as I know a datepicker is just that, a date picker so my guess is that you have additional code that adds the time in your userform or in the code that places the userform result in the worksheet.
You don't tell us the time value that's showing so without more information all answers are based on assumptions; assumptions, something you have to avoid at all times.

[torachan]

@mmikem, I would agree wholeheartedly with Keebellah, I steer clear if possible from the MS Date & Time pickers unless forced too by 'client'.
However I have used in the past and some of the attached may be of use, a couple of screen clips of the properties etc of the attached.
It is using the Worksheet_Change event in range A2:A100.
My preference is for speed data entry and I have attached a method I frequently used, enables use of the numeric pad only.
torachan.
Capture2.JPG
Capture1.JPG

[mmikem]

I found it the fix that is
When I loaded the DTPicker on to the user form Microsoft have a bunch of commands on the sub line DTpicker1_ by val etc etc etc ()
I removed them and just did DTPicker1_click() and now just have the date with no hrs mins with it

[Keebellah]

Tops, good to hear, happy coding