<div>
dear carlosab,<br />
<br />
If the macro should be executed automaticaly when entering the date in carone you can do two things, <br />
<br />
A) put on your sheet a combo box where the carone date has to be put. Use the Private Sub ComboBox1_Change() to look for changes in the combo box.<br />
B) use the Private Sub Worksheet_Change(ByVal Target As Range) to look for changes in your cell and then execute the macro.<br />
<br />
<br />
If you need an example of both possibilitys just ask and I will send you a excel...<br />
<br />
Kind regards<br />
<br />
Eric
</div>


dear carlosab,

If the macro should be executed automaticaly when entering the date in carone you can do two things,

A) put on your sheet a combo box where the carone date has to be put. Use the Private Sub ComboBox1_Change() to look for changes in the combo box.
B) use the Private Sub Worksheet_Change(ByVal Target As Range) to look for changes in your cell and then execute the macro.


If you need an example of both possibilitys just ask and I will send you a excel...

Kind regards

Eric

<div>
<div class="content wysiwyg-content">
I am in Excel and need a macro to evaluate a date that a user input into a cell that I've named &quot;CarOne&quot;. If the date is not at least 910 days old, then I need a message box to appear which says &quot;You have to wait until &lt;X&gt;&quot; where &lt;X&gt; is a date 910 days after the date in CarOne.<br />
<br />
Thanks!
</div>
</div>


I am in Excel and need a macro to evaluate a date that a user input into a cell that I've named "CarOne". If the date is not at least 910 days old, then I need a message box to appear which says "You have to wait until <X>" where <X> is a date 910 days after the date in CarOne.

Thanks!

Basic question about Excel Visual Basic

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

Microsoft Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.