Hi,
I currently have a DatePicker function in my excel spreadsheet and was wondering if there was a way for the calendar to show only when the cell is selected, and to disappear when the cell is not selected anymore?
Ideally would want to be able to:
1) Click cell A1
2) Select the date from DatePicker
3) Date selected will fill cell A1
4) DatePicker disappears when I click somewhere else.
Such that, if I wanted to change the date again, I could just click Cell A1 and step 1 would repeat again.
I was able to get the datepicker to disappear after selecting the date using this code:
Private Sub DTPicker21_CloseUp()
DTPicker21.Visible = False
End Sub
But when I click Cell A1 again, I could not get the DatePicker to show up again. Any help would be great.
Thanks!
Bookmarks