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
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