Posts by newgirl

    Hi royUK! I tried your 2nd suggestion but it is still not according to what I need. I made some tweaks with your code and below is the final one I made. Thank you so much for your help!


    I'm new to VBA. How can I combine 2 worksheet change commands? I tried to do it as such below but only the first portion works.

    Basically, what I want is that when user inputs "56765201 MEALS" or "56855753 ENTERTAINMENT EXPENSES" or "56855777 MEETINGS" under column D, a msgbox will pop up (the message would depend on the input.

    And then in Column F, if the date they input is more than 90 days from current date, then a MsgBox should appear.

    Hope somebody can help me out!