CuriousGeorg
02-03-2014, 01:34 AM
Good morning,
I run a small validation check on a userform (XL 2007) when a handler clicks ok.. for example "it textbox1 empty then "msg box".
How do i run the validation to be
If this date b is before date A "msg box"
The complicated thing is that I run the dates input as three boxes.. this is validated onto the spreadsheet as follows:
.Offset(RowCount, 5).Value = CDate(Me.cboDay1.Value & "/" & Me.cboMonth1.Value & "/" & Me.cboYear1.Value & " " & Me.TextBox1.Value)
.Offset(RowCount, 6).Value = CDate(Me.cboDay2.Value & "/" & Me.cboMonth2.Value & "/" & Me.cboyear2.Value & " " & Me.TextBox2.Value)
IS this even possible? as in when I exit the last boxes rather than just on validating on "OK"?
I run a small validation check on a userform (XL 2007) when a handler clicks ok.. for example "it textbox1 empty then "msg box".
How do i run the validation to be
If this date b is before date A "msg box"
The complicated thing is that I run the dates input as three boxes.. this is validated onto the spreadsheet as follows:
.Offset(RowCount, 5).Value = CDate(Me.cboDay1.Value & "/" & Me.cboMonth1.Value & "/" & Me.cboYear1.Value & " " & Me.TextBox1.Value)
.Offset(RowCount, 6).Value = CDate(Me.cboDay2.Value & "/" & Me.cboMonth2.Value & "/" & Me.cboyear2.Value & " " & Me.TextBox2.Value)
IS this even possible? as in when I exit the last boxes rather than just on validating on "OK"?