<div>
murbro: I suggest you should have waited for some more time before selecting an answer. I am sure there are several mvp's who could have confirmed what I said is correct or not.<br />
<br />
Sid
</div>


murbro: I suggest you should have waited for some more time before selecting an answer. I am sure there are several mvp's who could have confirmed what I said is correct or not.

Sid

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I have no idea what happened to the Active X calendar control in Excel 2010<br />
so I have built 3 ComboBoxes with day, month and year.<br />
What VBA do I use to gather the integer date from these 3 boxes and compare <br />
it to a cell value of &quot;2010/12/31&quot;<br />
thanks
</div>
</div>


Hi

I have no idea what happened to the Active X calendar control in Excel 2010
so I have built 3 ComboBoxes with day, month and year.
What VBA do I use to gather the integer date from these 3 boxes and compare 
it to a cell value of "2010/12/31"
thanks

Excel VBA - date format and Active X

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