Not sure why this query does not work

[Michael Island]

Hi,

I'm trying to activate a CommandButton next to a field as late in the writing of the string as possible.
He is typing out his email address and for some reason this does not work:

If Len(TextBox8.Value) + Len(TextBox7.Value) + TextBox5.Value = TextBox4.Value Then
CommandButton2.Enabled = True
End If

TextBox8 is a string
TextBox7 is a string
TextBox5 is a number
TextBox4 is a number

TextBox8 is the string after the "at"
TextBox7 is the string before the "at"
TextBox5 is the count of "at" in the email as a number
TextBox4 is the numeric length of the whole (incl. the "at" symbol) email.

[Arkadi]

Textboxes 4 and 5 may contain numbers, but to Excel they are still strings. You may need to also verify that they contain a number to avoid errors, but the calculation would probably work better if you use Clng(Textbox5.Value) and same logic for Textbox4. Just a quick guess since there is no sample workbook or broader code.

[Michael Island]

Hi,

Using that in mind I did a Len against itself so the answer would be a number and it worked fine. Thanks