Date Picker Visibility

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!

Thanks for your help!

You're welcome! Thanks for the rep, and thanks for marking your thread Solved!