Replace DTPicker with VBA code in UserForms

[johnw993]

Part of this question was answered by Forum Guru member JasLake (who has been very helpful), but I don't know how to contact Forum members individually, so I'll post my question to the Forum.

I'm struggling with replacing the DTPicker function in UserForms. I found and downloaded JasLake's frmCalendarv.102.zip file (see link below) and have installed it in my workbook and it is working wonderfully! I recommend it to everyone who is looking for an elegant Calendar look-up solution (and to replace the now defunct DTPicker).
It is working great in all the sheets within the Workbook, but how can I make this work the same way in UserForms?

I've been experimenting, but this is getting beyond my pay-scale.

Here is JasLake's file that I've used to replace all the DTPicker fields in my workbook. I like to know what edits I need to make in order to have the same functionality within UserForms.

I assume that I can share this within the Forum rules?

http://www.excelforum.com/attachment...endarv1.02.zip

Thank you!

John

[jaslake]

Hi John

Please Note...this Code is NOT my creation...merely an adaptation.

Post #3 of this Thread has an example of a Non Activex Calendar Control in a User Form.

http://www.excelforum.com/excel-prog...userforms.html

Need help adapting let me know.

[johnw993]

Once again, thank you JasLake. Thanks to your feedback and input, things are working wonderfully here.

[jaslake]

You're welcome...glad I could help.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[johnw993]

I don't want to pollute this Forum with unnecessary messages, but I do want to send a heartfelt Thank You to jaslake. By helping me solve the question in this thread, you've helped me solve the same challenge in several other applications I've been trying to make work. Thank You!!