Compare to toadys date

[mark-ainsworth]

hi,

I'm very new to VBA and I want to write a simple if statement like this:

If date (in cell D18) is equal to (today's date)
then do (code)

So what i have tried is this:

Please Login or Register  to view this content.

This hasn't worked - any advice?

Thanks,
Mark

[romperstomper]

Try:

Please Login or Register  to view this content.

I added CLng in case you have time values in there too.

[contaminated]

Try this

Please Login or Register  to view this content.

[mark-ainsworth]

Try:

Please Login or Register  to view this content.

I added CLng in case you have time values in there too.

Not working... here's all my code:

Please Login or Register  to view this content.

Thanks,
Mark

[romperstomper]

What specifically do you mean by 'not working'? The code itself is fine, so seeing a sample workbook might be helpful.

[mark-ainsworth]

What specifically do you mean by 'not working'? The code itself is fine, so seeing a sample workbook might be helpful.

It says variable not defined - not sure which variable? anyway - workbook attached...

Thanks,
MArk

[romperstomper]

That's because in this line:

Please Login or Register  to view this content.

you had typed x1up rather than xlup...