Calendar Function in Excel 2010 64bit

I have Excel 2010 64bit installed for specific reasons but from what I read I lose the ability to use the Calendar Picker from the Active X controls. I have a form in Excel and in some cells I would like to have the ability for a user to click on the cell and have the Calendar pop up to enter in a date. Other must haves are, the date must be blank to begin with and once set it is saved with that date when reopening the file. All cell's where there is a calendar, the date will be entered at different times.


Is this still possible with my version?

Thanks again guys! I really appreciate any help on this.

Originally Posted by alansidman

check this link: http://answers.microsoft.com/en-us/o...5-1a2606f43a5d

Thanks for this, it works great, the VBA Version. This VBA Macro executes when you double click any cell. Is there a way so it only executes on a specific cell. That way the other cells, I can have the user use the double click to edit text. The Cells where I would like this Macro to work on are B5, F13, H13, G24:G29 and H24:H29, H34.

Here is the current code:

Please Login or Register  to view this content.

Attached is the sample macro.

Calendar_Class_v1.1.0_DatePickerOnly_v2.xlsm

Thanks again.

Would anyone know if that is possible to enable the VBA Double Click function on specific cells vs. the whole worksheet?

Thank you so much

I found a solution, here is the code incase it helps someone else out:

Please Login or Register  to view this content.

I can't get something else working. In the range of cell you see above in the latest code, I have typed "Double Click to Enter Date", but if someone double clicks and enters a date and then decides a date is not required then the user would delete the date but then the cell is blank. I am looking to find a way where if the cell is blank for the range above the text "Double Click to Enter Date" should be presented. any ideas?

Thanks

Originally Posted by jaslake

Hi antexity

If I understand...

Don't have 2010 64 bit but you can try this.

Please Login or Register  to view this content.

Hey John

Thanks for your reply. It works but doesn't haha, if I input a date and then delete its blank. In order to get the text into the cell I have to double click. Makes sense as double click executes the script. So I guess what I need is something that runs automatically that is separate to the script.

I am assuming just make another Private Sub?

Thanks for your quick reply

This is perfect, it solved my issues, Thanks Jaslake and alansidman for your help. Reputations have been left