<div>
Why not set the date in the userform Initialize event?<br />
<br />

<pre><code id="code-20-34883346-1">Private Sub UserForm_Initialize()
    Calendar1.Value = Date
End Sub</code></pre>
<br />
Sid
</div>


Why not set the date in the userform Initialize event?



Private Sub UserForm_Initialize()
    Calendar1.Value = Date
End Sub


Sid

<div>
<div class="content wysiwyg-content">
Hi all <br />
<br />
In Excel 2007 I am building an Input form. &nbsp;On the input form I have inserted a Calender Control (12.0) that the user will select a date from. &nbsp;In the Properties of that Calender Control I have linked it to cell C6 of my form. &nbsp;However, the &quot;Value&quot; always comes up with either &quot;Null&quot; as date selected or a hard keyed date. &nbsp;Is there a way to default the Calender Control date to Date() or Today(). &nbsp;I've tried both and it doesn't save. &nbsp;It appears I can set the Calender Control Properties &quot;ValueIsNull&quot; to either True or False. &nbsp;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.<br />
<br />
Any help?
</div>
</div>


Hi all 

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.

Any help?

Excel 2007 and Calender Control

VBScript (Visual Basic Scripting Edition) is an interpreted scripting language developed by Microsoft that is modeled on Visual Basic, but with some important differences. VBScript is commonly used for automating administrative and other tasks in Windows operating systems (by means of the Windows Script Host) and for server-side scripting in ASP web applications. It is also used for client-side scripting in Internet Explorer, specifically in intranet web applications.

VB Script

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.