Message Box, Due Date

[Ecotox]

Hello guys. I was looking for a little help. I am trying to generate a message box to notify me whether a cell within a column (M) has today's date. I want the message box to display the cell address. I have explored the forums and I am able to return the first cell in the column with a date (some cut and paste with a little modification). I am a newbie. No coding experience in years. Below is what I have done thus far. I don't know how to obtain results for multiple cells with Today's date.

Please Login or Register  to view this content.

Any help is greatly appreciated. This code above may be overkill for what I am trying.

[HaHoBe]

Hi, Ecotox,

please have a look at Forum Rule#3 to understand why you are asked to apply code-tags to your procedure.

Ciao,
Holger

[HaHoBe]

Hi, Ecotox,

if you want to use FIND you have to do a loop for as mayn times as there are ranges in your range.

Please Login or Register  to view this content.

Have you thought using the Autofilter and use SpecialCells(xlCellTypeVisible) for Column M to get the information you want?

Ciao,
HOlger

[Ecotox]

I haven't tried that method. I will investigate it more. Thanks.

[Ecotox]

Solved.

Below is the method I have used. I am still learning, so some of the code may be unnecessary due to some cut and paste from other projects.

Please Login or Register  to view this content.

Thanks for the assistance.