dt picker- requiring a selction to be made 1

[MagnumPI4]

I have created a user form that will send data to an excel file. I have several combo boxes and two dt pickers in the form. I have added code to give a message box if the user does not enter data in the combo boxes, but I can't figure out how to do the same for the dt pickers. Any ideas?

Here's what I'm using for the combo boxes:

'check for a downtime category
If Trim(Me.cboCategory.Value) = "" Then
Me.cboCategory.SetFocus
MsgBox "Please enter a Downtime Category"
Exit Sub
End If

I am brand new to VBA, so please "type slowly." Thanks.

 

[SkipVought]

Hi,

How does this code fire?

You might consider a validation procedure that you run when the user hits the control to populate the worksheet.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[combo]

You can use the same method:

If IsNull(Me.DTPicker1.Value) Then
    Me.DTPicker1.SetFocus
    MsgBox "please select date"
End If

(assumed you have a checkbox inside, otherwise DTPicker does not accept null value).

combo

 

[MagnumPI4]

Thanks folks! Combo- your code worked perfectly. I had been trying it with Value="" instead of IsNull. Your way made all the difference.