Using Datepicker in Userform VBA compatible to Excel 2013 64bit and 2007 32bit

Hi ashburnadam,

Bad news and Good News.

Bad: DatePicker is not compatible with 64 bit Excel.

Good: There are alternatives. See post #13 and #16 in the following thread for links to free 100% VBA alternatives:
http://www.excelforum.com/excel-prog...r-control.html

Lewis

@Lewis - you're right, that's why I use a decent alternative that is rather flexible.
I don't get why there's no default datepicker control in excel that is a) compatible with multiple excel versions and b) portable...
Anyway, check out my attached file, that seems to work fine

Originally Posted by JasperD

Try attached.
Attachment 408184

Hi JasperD,

Currently I can only select the date using mouse only. How I can code it so that keyboard also will enable to select it? (I mean using Tab on keyboard for scrolling).

Thanks.

Do what it says - update them with the PtrSafe attribute

To answer your other question - it can be done, but it's too much work for me to do so ;-)

Originally Posted by JasperD

Do what it says - update them with the PtrSafe attribute

To answer your other question - it can be done, but it's too much work for me to do so ;-)

I have been trying to find the solutions to PtrSafe attribute. How do I update them.

I am so confusing right now.

I realize I am resurrecting an old thread, however, I am looking to use a date picker option for a macro I am using - I want to print a selection of sheets in a workbook based on a date in a particular cell on each sheet. I have the macro working, however, I would like to use a date picker to select the date versus entering it manually. I took a brief look at the date picker in the above file. I'm sure I can figure it out, was just wandering if there is something Microsoft has recently added? I will take a closer look at this and see if I can get it to work for my purposes.