Bypass Run-time error '13'?

[CuriousGeorg]

Good morning,

I know why I get the above error, it appears when a certain field in the userform is empty (the last set of number)

Is there a way I can by pass this or get around it ?

[Aussiebear]

First impression is fill the field with a value. If its numeric then a zero should suffice.

[CuriousGeorg]

If there something in it.. its fine date.JPG is the part of the user form that breaks

and this is the code to send it to spreadsheet

.Offset(RowCount, 14).Value = CDate(Me.cboDay3.Value & "/" & Me.cbomonth3.Value & "/" & Me.cboYear3.Value & " " & Me.TextBox3.Value)


I'm assuming its because I'm asking the VBA to input / when there's a blank entry?


EDIT: figured a work around.. not ideal.. but ive removed CDate.. and formatted the cell in the workbook. Few rounds of testing and ill need to ensure it pulls a date through correctly.

[snb]

.Offset(RowCount, 14).Value = CDate(cboDay3.Value & "/" & cbomonth3.Value & "/" & cboYear3.Value) + format(TextBox3.Value,"0.0")