format now() to date

[gregvb]

when writing vba code, how do i format now() to mm/dd/yyyy so that if i'm searching for a today in a worksheet, it will locate todays date?

[Leith Ross]

Hello Gregvb,

You can do it this way...

Please Login or Register  to view this content.

Now you can compare Today from a cell with myDate in your code and test if they are equal.

Sincerely,
Leith Ross

[gregvb]

that didnt work for me. Perhaps I should be searching for the excel number date (eg 39198) instead. Is there a way to format now() to that?

[Leith Ross]

Hello Gregvb,

Post the code you are using to find today and compare it.

Thanks,
Leith Ross