Coding Command Button on Userform Excel VBA

Please login in order to report media.

  • Uploaded 8 months ago in the category How to programming

    Dear Mr Dinesh

    Thanks to your videos I got used little by little to the use of the userform in excel 2010.

    I found it very interesting and I even (after a long job) realized a userform for entering accounting data (debit and credit).

    The userform works very good and all the data is transferred to my worksheet when I press the bouton "Add data" .

    I also created in my form a second bouton to exit the userform.

    This bouton is working very fine.

    To tell you the truth I have no idea of coding in VBA (I am an accountant)
    So I want when I press the bouton "Exit" a messagebox inform me that the total of "debits" is not equal to the total of "credits"
    Of course if there's a difference in my worksheet between the row debit and credit.

    If there's no difference there's no msgbox
    Thank you an advance

    Yours Hichem

    Complete code details are available here:

  • codingcommandbuttonuserformexcelvba