Is there a way to have a cell that is in a different sheet in the same workbook that your working in, alert you that it's still an empty cell and needs to be looked at?
Is there a way to have a cell that is in a different sheet in the same workbook that your working in, alert you that it's still an empty cell and needs to be looked at?
It is possible depending on a condition.
What is the condition that should trigger the alert? (ie: When you open the workbook, when a calculation changes values, etc??)
Regards,
Rudi
The simple way to do this is write the code given below on every sheet except sheet1. The code will trigger an alert if cell A1 on sheet1 is blank while you activate other sheets. The code is.........
You can change the code in the Red color as per your requirement.Please Login or Register to view this content.
For detail see the attached sheet.
Is this what you want?
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
That is exactly what I'm looking for, thank you!
You don't have to put the code in every sheet. You can just put this in the Workbook Class module:
Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I'm just learning to use the VBA, I will try this. I appreciate the help, it just takes me a little more time to mentally process it and apply it than the average excel user, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks