Drop Down Calendar in Excel with a Default Value

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
 
L

lhkittle

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtered drop down list 2
How do I create a drop box in Excel to show a calendar? 1
Calendar Drop Down List 2
Drop down Calendar in Cell 1
Pop Up Calendar 1
Data Validation drop-down 5
Calendar drop down ala Ron DeBruin in Excel 2003 6
drop down list based on other drop down list pick 1

Top