simple error message if text box is empty

Question

I have a userform which I can calculate the VAT of a certain item.

I have a Net Textbox, VAT text box, a current %VAT textbox and a calculate command button.

On calculation the code I am using is

txtVat = txtNet / 100 * Percentage

I have added 

If Percentage = "" Then

MsgBox "Enter the VAT% you wish to use to calculate with"

End If

To appear of there is not VAT% inserted in the %VAT textbox. This works fine for the error message, but when I click OK on the msgbox I get Debug

what am I missing from my code.

Thanks

Steve

Answer 1

You could exit the calculation:

    If Me.Percentage = "" Then

        MsgBox "Enter the VAT% you wish to use to calculate with"

        Me.Percentage.SetFocus

        Exit Sub

    End If

Answer 2

Cheers Hans

I had actually tried your code, but in a different way, hence it not working. this is great thanks

Steve