Date Format in a User Form in Excel

[culcuhain]

Good morning,
I am not quite awake yet.
I cannot for the life of me this morning find in the VB where I can limit the entry on a form to a date format. Any insight would be great!!

Thanks!!!

Lee

 

[RoryA]

Your best bet is to use the Exit event of the textbox with IsDate to check if the entry is a date.

 

[CWatts]

I just recorded a macro and set date validation and pulled the code:

Sub DateValidation()
    With Selection.Validation
        .Delete
        .Add Type:=xlValidateDate, AlertStyle:=xlValidAlertStop, Operator:= _
        xlBetween, Formula1:="1/1/2010", Formula2:="12/31/2011"
        .IgnoreBlank = True
        .InCellDropdown = True
        .InputTitle = ""
        .ErrorTitle = ""
        .InputMessage = ""
        .ErrorMessage = ""
        .ShowInput = True
        .ShowError = True
    End With
End Sub