Pop-up calendar when selecting cell

[G.Bregvadze]

Hi,

Currently, I work on a project in an excel file where I would like to insert a pop-up calendar on specific cells, where after selecting cell a pop-up calendar will be displayed, the user is able to select a specific date and than this date is inserted in this cell.

There are many ways to do that, however I could not find any efficient way, some offer Add-ins, some offer Microsoft Excel integrated active X control, however it does not offer what I described above, or I was unable to use it correctly.

It would be helpful if someone will provide any efficient way to reach above mentioned result.

[zbor]

Something like this: http://www.fontstuff.com/vba/vbatut07.htm

[G.Bregvadze]

Yes that's right.

But I could not use it, could you please provide some sample file?

[zbor]

You have sample files at the end of the page

[G.Bregvadze]

Yes, but can't use, it, the macro is ran after I click to run macro, however I would like to make the code usable when the workbook is opened and run macro when selecting a specific cell.

[zbor]

You can call that macro in any part of the code you like.

[G.Bregvadze]

If possible please help me to modify this file from the web page, to run it after specific cell is selected

[G.Bregvadze]

Please help to modify code from above posted link.

The idea is to run the code after selecting the specific cell, display calendar and choose date, after that the date is placed in the cell

[G.Bregvadze]

Can anyone help to modify this file so the Calendar appears when you select as specific cell, for example A1, A2, A3 and when the date is chosen the date is entered in the same selected cell.

Sample file:
Calendar.xlsm

[G.Bregvadze]

I already found some clue, I managed to activate calendar after selecting specific cell, However I have some sort of bug: the calendar should be activated when selecting only a cell, but in my case it is also activated when highlighting several cells.

Please help to modify the code in order to exclude activation of calendar when highlighting the cells.

Updated file with calendar activated for selected cell:
Calendar with cells.xlsm