sum text boxes and skipping errors

[esaban]

I have 8 text boxes that I sum automatically using a command button. Occasionally I will need to have 'FALSE' in one of the text boxes, but will get a Run Time error '13' type mismatch. Essentially what I want to do is continue summing the other text boxes. any help is appreciated.

[Marc L]

Just read IsNumeric and Val functions VBA help …