Excel 2007 and Calender Control
Posted on 2011-02-13
In Excel 2007 I am building an Input form. On the input form I have inserted a Calender Control (12.0) that the user will select a date from. In the Properties of that Calender Control I have linked it to cell C6 of my form. However, the "Value" always comes up with either "Null" as date selected or a hard keyed date. Is there a way to default the Calender Control date to Date() or Today(). I've tried both and it doesn't save. It appears I can set the Calender Control Properties "ValueIsNull" to either True or False. However if it is set to True then no date is slected and if it is False then a non dynamic date is in the field.