Problem when Exiting UserForm

  • Hi all,


    Here is the part of my code in the UserForm object which faults if the UserForm is closed without entering any data:



    The second line is causing it, as there is an error dividing nothing by 1.1 - and I do understand why.


    There needs to be some kind of error trapping where the line (and the line two lines down, too) is ignored if there is nothing in the GST_Incl_txb textbox, but nothing I've tried seems to work.


    Does anyone have any ideas?


    Thank you,

  • Try

    We now have a reputation system in place. If my reply helped please "Like" the reply by clicking the "Like" icon at bottom right of my reply.

Participate now!

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