Pop up when date reached

[Davycc]

Hi peeps

a very simple one here I've copied different codes and tried adjusting them to suit but with no joy. I have attached a simplified version of a sheet I'm using for which I require a pop up box to appear when opened containing the details in a certain cell when the relevant date is passed. I would like individual pop ups for each instance if possible. I need this to work for all 3 sheets in the book.

If I already have a pop up box upon opening giving instructions will this need to be removed (not in the example).

Cheers

[judgeh59]

If I understand what you are trying to do....this may get you close....

basically when you open the file it determines the amount of rows, then loops through the row comparing column "H" dates with today. Then using msgbox displays pieces of information....HTH

[Davycc]

Cherrs judgeh59

Yest thats just what I need (I attached the wrong example file sorry) how do I have it work for the three sheets in the new attached file.

Again what you suggested is perfect but not sure how to setup all the sheets.

David

[judgeh59]

no problem---this should do it for you....you can change the data display in the msgbox....

[Davycc]

Thanks so much for that it's bang on. I was going to start setting up conditional formatting to another sheet for each one then use your code to for that sheet probably wouldnt have worked and def no as good as this.

Thanks again

David

[judgeh59]

glad I could help and thanks for the rep point....have a great day....

[Davycc]

Oops spoke too soon,

OK I tried to be smart but its backfired, I thought I only needed the code for those "review" sheets and then I would adjust to suit. Turns out I'm too thick to do that. I've removed all the data from my file and saved it with new name (attached) I need the code for only the review sheets

Thanks again

David

[judgeh59]

this should work...

[Davycc]

Works perfectly when the exact date is reached can it show for when its passed the date as the sheet may noe be opened every day so may miss the exact day....

sorry for being a numpty.

[judgeh59]

sure, just change the macro code from an "=" to a ">=".....now this may cause a problem to ones that have already been reviewed....so you may need to adjust the code to determine if a review took place....I haven't looked at the file enough to know if there is a column that shows that row has been reviewed....

[Davycc]

Cheers really appreciate your help on this for me (if they don't reset the review date then they will be the ones getting the grief lol)

Again many thanks, I'll leave you in peace now.

[judgeh59]

works me for....no problem at all....have a great day....

[Davycc]

Sorry

[judgeh59]

okay...that's not real helpful.....I did get an error when opening it directly from this website....just click END and save the file to your location....

Also, when I ran it and got no data in the fields....I forgot to put the Sheet reference in the Msgbox area....my bad....

does this cover "Sorry" ......

[judgeh59]

oh sure here is the file....sorry

[Davycc]

OK I tried running it adding date removing dates entries etc and now its doing exactly as I need, thanks again really great help.

[judgeh59]

not a problem....we want that sucker to work...

[Davycc]

Ignore Please