Drop Down Calendar in Excel with a Default Value

  • Thread starter Thread starter Jes Waddell
  • Start date Start date
J

Jes Waddell

Hi All,

I'm using the drop down calendar function in vba and I want when you open my document there to be no date showing for that drop down field because it's not something that will always be used. I can't seem to figure out how to make that work.

Thanks,
Jes
 
Hi All,



I'm using the drop down calendar function in vba and I want when you open my document there to be no date showing for that drop down field because it's not something that will always be used. I can't seem to figure out how to make that work.



Thanks,

Jes
Click to expand...

Try this in the ThisWorkBook module, change H1 to your dropdown cell.

Option Explicit

Private Sub Workbook_Open()
Range("H1").ClearContents
End Sub

Regards,
Howard
 
Back
Top