VBA date function

[tingen]

I want to check if a date in a cell is before the current date.
How can i do that (in VBA code)

Please Login or Register  to view this content.

[johnjohns]

try

Please Login or Register  to view this content.

rgds
johnjohns

[royUK]

Why not just use Conditional Formatting?

[tingen]

thanks johnjohns
it works ^^

[royUK]

It will only work if your users enable macros, so Conditional formatting would be the best option & faster

[johnjohns]

RoyUK is right. If at all possible, use excel's built in functions. Macros and array formulas should be of second preference always

rgds

johnjohns

[DonkeyOte]

I wouldn't always go along with that myself... Conditional Formatting is super volatile so on occasion using VBA to control the formats as and when required would be deemed preferable.