Hi all

I'm having trouble with this If statement as i'm getting "Typemismatch 13" on Textboxes with blank values.

I have to check all of the Textboxes at once for this to work. Textboxes 1-3 will have whole numeric values "10,000" and Textboxes 4-6 are either decimals or whole numbers "24" or "24.4".

When one of the textboxes are blank I debug with a typemismatch. Any ideas?

Thanks

If CInt(textbox1.Value) >= Sheets("Sheet1").Range("H31").Value Or _
CInt(textbox2.Value) >= Sheets("Sheet1").Range("H33").Value Or _
CInt(textbox3.Value) >= Sheets("Sheet1").Range("H32").Value Or _
CDec(textbox4.Value) >= Sheets("Sheet1").Range("G31").Value Or _
CDec(textbox5.Value) >= Sheets("Sheet1").Range("G33").Value Or _
CDec(textbox6.Value) >= Sheets("Sheet1").Range("G32").Value Then