When a user enters a cell (merged or not) that is formated with a date format, I want to pop up a button right next to the active date formatted cell?
Then I want this button to open a date picker/pop-up calendar right next to the button. Then when the calendar closes... so does the button.
I have created a pop-up calendar from http://www.fontstuff.com/vba/vbatut07.htm then I coded it with code from http://www.fontstuff.com/mailbag/qexcel02.htm to automatically open the calendar when specific cells were activated. It works great as long as the specific cells are not merged. However I have to merge them. Unfortunately the integrity of the spreadsheet is more important than the calculator. I also need dates all over the workbook... so this solution will actually work better.
Then I want this button to open a date picker/pop-up calendar right next to the button. Then when the calendar closes... so does the button.
I have created a pop-up calendar from http://www.fontstuff.com/vba/vbatut07.htm then I coded it with code from http://www.fontstuff.com/mailbag/qexcel02.htm to automatically open the calendar when specific cells were activated. It works great as long as the specific cells are not merged. However I have to merge them. Unfortunately the integrity of the spreadsheet is more important than the calculator. I also need dates all over the workbook... so this solution will actually work better.
