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
Bookmarks