Add Error Messages with VBA

    • New

    Hello All,


    I need so assistance, I have the attached vba code assigned to a button for Archiving Payment data on a monthly basis from sheet1 to another worksheet (Historical Payments).

    And it’s working perfectly, I just need to add a couple error messages once they click on the button: 1) Previous Payment Date has not been Archive…go to 0. 2) This Payment

    Date has already been Archive…go to 0. The designated date is on cell E3 of the sheet1. I would greatly appreciate the assistance!


    Cheers,

    GD

    • New

    Hi,


    You are lucky enough to participate in a Forum which allows ... to Attach a Sample File ... :)


    Images are dead and useless objects ... whereas a sample file is just IDEAL !!! ;)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

  • Carim

    Changed the title of the thread from “Need help with VBA” to “Add Error Messages with VBA”.
    • New

    Hi again,


    Sorry ... but in order to Add a couple of error messages, such as :


    1) Previous Payment Date has not been Archived

    and

    2) This Payment Date has already been Archived


    You will agree there is a need to compare a given date to another reference date ...


    So, could you explain precisely what needs to be compared to what ? :)

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login