| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down Calendar in Excel with a Default Value
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop Down Calendar in Excel with a Default Value
On Tuesday, June 4, 2013 7:32:42 PM UTC-7, Jes Waddell wrote:
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 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I add a drop-down calendar in excel? | Excel Worksheet Functions | |||
| How can I set up a drop down box with a calendar in Excel? | Excel Programming | |||
| how do I add a calendar function to excel as a drop down? | Excel Worksheet Functions | |||
| How do you create a calendar drop down in excel? | Excel Programming | |||
| How do you create a calendar drop down in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
