Avatar of Smith William
Smith William
Flag for United States of America asked on

Reminder/ Code VBA

Hello Experts,

Please have look at my attched file. I am looking for reminder pop up when i open excel for the work not done. Pop up should come up when the work status is "NO".

Pop up -Work No...... is not yet done.

Please code for me.


Thank you in advance.
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Martin Liss

You didn't actually attach your workbook.
Smith William

ASKER
Martin Liss

Do you want the message to list all the "work" values where column "B" is "No"?
Your help has saved me hundreds of hours of internet surfing.
fblack61
ASKER CERTIFIED SOLUTION
Martin Liss

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Martin Liss

The attached workbook contains a macro that uses better grammar.
29065104.xlsm
Smith William

ASKER
Thank you sir. Looks very good. Have a great weekend
Martin Liss

Please don't forget to close the question.
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Smith William

ASKER
Thank you Sir. It was great CODE.
Martin Liss

You're welcome and I'm glad I was able to help.

If you expand the “Full Biography” section of my profile you'll find links to some articles I've written that may interest you.

Marty - Microsoft MVP 2009 to 2017
              Experts Exchange MVE 2015
              Experts Exchange Top Expert Visual Basic Classic 2012 to 2017