I have a field on my spreadsheet where I have a pop-up calendar linked to the field. Please see attached file for spreadsheet.
If I click in that field then the pop-up calendar appears. If I click in another field then the calendar pop-up window closes.
Here is the logic I use to make this happen:
The problem I have is that when I execute my macro logic to clear my Invoice worksheet and then select and activate the date field my pop up window does not appear.
How do I get the calendar pop-up window to appear after I clear the window.
Here is the logic below that I use to activate the date field after I clear the Invoice worksheet.
Bookmarks