Textbox issue on userform

[yabbadabba]

hi guys, just having problems if the textboxes in the code below are blank. Works fine if there is a number in the textboxes. Any help would be appreciated.
Thanks


If CheckBox31 = True Then
Sheets("Times").Range("k7") = Sheets("Rates").Range("b2") * 8 + TextBox48.Value * Sheets("Rates").Range("b3") + TextBox38.Value * Sheets("Rates").Range("b4")
End If

 

[Andrew Poulsom]

Welcome to MrExcel.

Try using eg Val(TextBox48.Value).

 

[yabbadabba]

works great.thanks