Pop Up Calendar

[trfountain22]

Does anyone know of a work around for creating a pop up calendar in a cell using 2016 64bit? The option to do it is no longer there and from what I've read it's only available using 32bit. HELP! I've attached the spreadsheet. Under the date column I want a pop up calendar to pop up so the date can be chosen.

Thanks,
Tara

[MarvinP]

OK trfountain,

See if you can double click in column B of first sheet to get what you want. Modify the code behind sheet 2 if you want it to work there too.

ESI PO List with Calendar.xlsm

[6StringJazzer]

Hmm. That looks strangely familiar.....

[trfountain22]

I'm just a beginner with excel. I do need it in sheet two also. How do I modify the code behind sheet 2? I attached the newer version of the spreadsheet. It works on sheet 1 but doesn't on sheet 2.

[trfountain22]

Marvin,
Thanks for helping me. I'm trying to figure this out but about to pull my hair out! I don't know what I did but now the PO numbers don't auto generate when I go to the next line. I'm still trying to get the calendar to work on sheet 2!

[trfountain22]

Marvin, where is the code???

[AlonCh]

Very interesting for me, thanks for valuable information

[6StringJazzer]

[...]now the PO numbers don't auto generate when I go to the next line. I'm still trying to get the calendar to work on sheet 2!

In the file you attached in this post, there is code to autogenerate a PO in sheet Security if you select a cell in column A. That works fine. Also in sheet Security if you double click on a cell with a date, the calendar pops up. Also fine.

There is no code in sheet Fire. Are you expecting the same functionality on that sheet? If so, just copy all the code from sheet Security to sheet Fire.

By the way, a With statement is redundant here, because the sheet for this code has to be the active sheet for the event to occur:

Please Login or Register  to view this content.

It does not cause an error but it makes the code a bit confusing. I would do this:

Please Login or Register  to view this content.

Also, I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bug and runtime errors.

[trfountain22]

Thank you so much!