Forum Discussion
WARJAMAND
Jan 30, 2022Copper Contributor
VBA Message Box Worksheet Change
Hi Group.. I want to create a VBA Script that will return a Message Box of: " Employee is Not Eligible for New York State Paid Leave" if the following criteria is met: If cell E19 = "CEO","...
mtarler
Jan 31, 2022Silver Contributor
first off, your link is to a shared FOLDER and I just guessed the file name as "VBA Question 2" because it was new. Not sure if you care to share all those files but you should either share the file or tell us which file to look at 🙂
That said, I first offer an easier and possibly better solution. In that file I created a simple IF statement to do what you want (cell G20) added with some conditional formatting to make it stand out and very clear notification. The reason I recommend this is that if they open the file online macros don't work, they also don't work if they have security settings at high or medium and decline letting them run. So this solution work in all cases and you can even lock the sheet (obviously unlock the cells they need to use/enter info into, which has to be done in the desktop version but works online) to prevent them from accidentally deleting that cell or hiding that row.
That said, I first offer an easier and possibly better solution. In that file I created a simple IF statement to do what you want (cell G20) added with some conditional formatting to make it stand out and very clear notification. The reason I recommend this is that if they open the file online macros don't work, they also don't work if they have security settings at high or medium and decline letting them run. So this solution work in all cases and you can even lock the sheet (obviously unlock the cells they need to use/enter info into, which has to be done in the desktop version but works online) to prevent them from accidentally deleting that cell or hiding that row.
- WARJAMANDFeb 05, 2022Copper ContributorThank-you for your tip regarding sharing OneDrive Folders/ Files....I really appreciate that information.
I like the If Statement that you presented, however I would still like to use a VBA Script to have a Pop up option.
Again .. Thank-you for your time!!
Regards!!