Displaying month in a pop-up calendar based on the month entered in the other cell

[srinath1611]

Hi

I have developed the pop-up calendar in excel using VB and macro. Now I am able to open a pop-up calendar by double clicking in a cell of any spread sheet.
I have one requirement.
Assume I enter a date by selecting from the pop-up calendar in a cell, say for example, I enter 25/09/2010 as date in cell.
When I open the pop-up calendar in another cell, I want the pop-up calendar to open 'Sep' month.

Presently, it is opening the current month instead of the month value entered in the other cell.

Please advise.

Regards
Srinath

 

[srinath1611]

Dear Andrew

Thank you very much.

It is working perfectly as per the requirement

Regards
Srinath