Pop up calendar

[tracktor]

I am sharing this with the community as I spent all day trying to find a pop-up calendar that will automatically open up when specific cells are selected. I hope this helps someone that had the same problem I had.

I am a complete novice. And I got this to work perfectly... with one exception. The specific cells can't be merged.

For the pop-up calendar go to http://www.fontstuff.com/vba/vbatut07.htm and follow the instructions.

To program the calendar to open automatically when the specific cells are selected go to http://www.fontstuff.com/mailbag/qexcel02.htm and follow the instructions there.

This is about the best way I can give back to this community. I really appreciate all the help I have received.

 

[wilcox96]

I am reviewing your information about a pop up calendar in Excel…(thank you very much!)…but had a quick question:

I am definitely interested in the option to make the calendar appear when the user enters a cell (actually, there will be several places throughout the form where this will occur). I will be distributing a form to many users. How do I make the pop up calendar reside and travel with the form, rather than having to have each user add the “add in”…or via the Personal.xls?

Also…will this work with multiple versions of Excel?

Thanks for your time.

 

[c_m_s_jr]

I am no wizard with VBA, but in order for it to travel with the form, you will need to input the code into your workbook containing the form.