Forum Discussion
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","...
Thank-You....I will check out and review once I get home. I really appreciate your time in helping me with this as VBA is not one of my strengths with Excel 😀
You're quite welcome. In addition to mtarler 's suggestions, I think another possible non-vba approach you could consider would be to use the filter function to filter out 'new york paid family leave' for ceos or founders so it's not even an option and use that as the data validation source for primary leave, But, you'd also have to apply data validation to the employee name so if primary leave was filled out first or left over from a previous input, it would force them to clear the primary leave field before selecting a ceo or founder.
- That is another Great Idea... Thank you again. I will look into this now.
Regards,
WARJAMAND