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.