I have created a pop up calendar using VBA.
I have two cells that require calendar input. The dates selected will be different from each other.
In each of the cells I have placed a calendar icon and programmed a macro to open the pop up calendar.
Question is: How to I make sure that when the user clicks on one of the icons that opens the pop up calendar that the selected date will populate in that specific cell? When the user moved to the next cell that needs calendar date input, should I assign the same macro to that icon?...bringing up the same pop up calendar? Will I be able to then have that specific cell filled in the with the selected date?
Bookmarks