srinath1611
New Member
- Joined
- Aug 17, 2010
- Messages
- 27
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
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