Display msgbox if todays date found in column a

[ANDREAAS]

Hi

I have the code below in my workbook open module and i want it to display a msgbox if Now is found in column A with format yyyy/mm/dd(typed in) but displays as dd mmm yyyy.
The code runs but does nothing. Please help.

Please Login or Register  to view this content.

[ANDREAAS]

can this perhaps be taken a step further an change the msgbox to something like "you have x appointments for today" where x is te amount of times now is found in column a?

[TMS]

Suggest that you provide a sample workbook. If the appointments have date and time, then I suspect that Find is not going to locate them based on just the date.


Regards, TMS

[ANDREAAS]

Cannot upload, working from my cellphone. Column a has only dates, I need to find how many times the current date is in column a and show in the msg box when the workbook opens

[TMS]

Just use COUNTIF then, comparing today's date with the dates in the column. No loop necessary, should be a lot quicker.

Please Login or Register  to view this content.

Regards, TMS

[ANDREAAS]

Work in my normal worksheet, but not in xlam even if I use "This1Workbook"

[ANDREAAS]

Error it gives in xla is runtime error 1004
Method range of object global failed

[TMS]

Thanks for the rep.

You will probably need to fully qualify the columns(1) with a workbook and worksheet reference.

so, maybe something like:

Please Login or Register  to view this content.

[ANDREAAS]

Ok so now its showing the msgboox,but it returns 0 eventhough todays date is present in column a. Think its the formatting and tried

Please Login or Register  to view this content.

And

Please Login or Register  to view this content.

and nothing works
Any ideas?

[TMS]

Any ideas?

No. Please post a sample workbook so I can see what you are working with. Maybe you need to specify the actual workbook name, rather than ActiveWorkbook or ThisWorkbook.

[ANDREAAS]

Thanks for your help and patience so far tms, really appreciate it.
I'll see if I can get a exaple loade tomorrow.
Have a great evening.

[ANDREAAS]

Hi tms
I got it to work!!!

Please Login or Register  to view this content.

[ANDREAAS]

Hi tms
I got it to work!!!

Please Login or Register  to view this content.

[ANDREAAS]

Don't know if this is the best or even correct way of doing it, but it works, so...
Thanks again for all your help tms, really appreciate it.

[TMS]

Sometimes, if it works, it works ... don't worry about it