<div>
Also, how are you entering the date values in the cell?<br />
<br />
Sid
</div>


Also, how are you entering the date values in the cell?

Sid

<div>
Thanks everyone.<br />
Answer to Sid' question - by code such as<br />
Range(&quot;D4&quot;).Value = myDateVariable<br />
<br />
I'll split the points between Zorvek and Teylyn.
</div>


Thanks everyone.
Answer to Sid' question - by code such as
Range("D4").Value = myDateVariable

I'll split the points between Zorvek and Teylyn.

<div>
Zorvek's detailed explanation is very helpful.
</div>


Zorvek's detailed explanation is very helpful.

<div>
<div class="content wysiwyg-content">
I have the dreaded green triangles when entering Date values into cells (with VBA). I want to lose them. I found this <br />
<br />
Application.ErrorCheckingO<wbr />ptions.Bac<wbr />kgroundChe<wbr />cking = False<br />
<br />
However this turns off the error checking globally and I don't want to leave the users with this condition. Is there a way of fixing this in code? I tried formatting the cells to Text prior to entering the values but that didn't work.<br />
Thanks!
</div>
</div>


I have the dreaded green triangles when entering Date values into cells (with VBA). I want to lose them. I found this 

Application.ErrorCheckingOptions.BackgroundChecking = False

However this turns off the error checking globally and I don't want to leave the users with this condition. Is there a way of fixing this in code? I tried formatting the cells to Text prior to entering the values but that didn't work.
Thanks!

Excel VBA - getting rid of the green triangle

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