PDA

View Full Version : I Need assistance with popup calendar macro in excel 2010



Hydra
05-20-2014, 07:12 AM
Good Day,

I am new to this site and Excel VBA.
I need to add a pop up calendar to specific columns in a spreadsheet and have managed to download a macro as the monthview control is not available in my version of windows/excel.

However, i need some changes made to the macro in order to make it work for my spreadsheet.

The changes are:
- Calendar should only work in columns B, C & R from row 3 all the way down.
- Calendar should pop up even when there is a date already in the active cell.
- Calendar must close when the date is selected by the user.
- the 'Ok' & 'Cancel' buttons must be removed.
- the calendar should close when ESC key is pressed.
- the calendar should pop up next to the active cell.

I know this is quite a bit of changes but i would really appreciate the assistance.
I have attached the macro.

Thank you in advance
Hydra