Calendar Macro

I tried the code and it doesn't seem to work. Please check attached file.

I would also like to activate when "B5" is active along with "A5".

Thanks for all your help!!!

Hi again,

You entered the code in a standard VBA module - you must enter it in the VBA module for the WORKSHEET. Right-click on the worksheet tab & select "View Code" - this will display the VBA module for the worksheet.

To extend the "activation range" use:

Const strCalendarCell   As String = "A5:B5"

Regards,

Greg M

It isn't working... Attached is actual file. I need it to activate in cell C7 & G7.

I get an error no matter what cell I click on. Thanks

In attached file i added a form and a calendar control in the form (to select a date use double click).

I hope it's what you need.

Regards,
Antonio