Forum Discussion

WARJAMAND's avatar
WARJAMAND
Copper Contributor
Jan 30, 2022

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","...
Macros and VBA
WARJAMAND's avatar
WARJAMAND
Copper Contributor
Feb 05, 2022
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 😀
mtarler's avatar
mtarler
Silver Contributor
Feb 05, 2022
if you want, it could be a hybrid solution that uses the IF() statement with conditional formatting AND the VBA macro so that if they have macros off or view the file online, they still get a notification.
  • WARJAMAND's avatar
    WARJAMAND
    Copper Contributor
    Feb 12, 2022
    Thank-you so much....I use conditional formatting on another tab. I thought I saw a YouTube video stating conditional formatting slows down Excel.

    Much appreciated & thank-you again!

    WARJAMAND
    • mtarler's avatar
      mtarler
      Silver Contributor
      Feb 12, 2022
      conditional formatting is another process excel must do so if you have a conditional formatting applied to 10,000 rows of data, yeah you might want to consider that. I really don't think you have anything to worry about in this case.
      • WARJAMAND's avatar
        WARJAMAND
        Copper Contributor
        Feb 13, 2022
        You Are The Best!!

        Regards,WARJAMAND