A MSG pop up box if a value entered in a column matches a value on another sheet RRS feed

  • Question

  • Here's the deal,

    I have a database with several sheets (One per month) and in column D I enter a client number for each transaction.

    Each client has several transactions each month.

    Today, one of my clients requested a payment they weren't entitled to and as the admin assistants were not aware the account was closed, they paid it (My fault, I should have informed them) Anyway, I am going to add a sheet to list all of the client reference numbers whose accounts are closed, and what I'd like to do is, if a closed accounts reference number is entered into column D, A vba recognises it from the list and pops a message up saying "Account closed"

    Can it be done?

    PS - No idea what happened to the font.

    Many Thanks


    Monday, October 8, 2018 10:15 PM