Validate Date

Public Sub DateValue()

     Dim strDate As String
          strDate = InputBox("Tape a Date", "Date", Date)

     If strDate <> "" Then
          If IsDate(strDate) Then
               Range("B2").Value = strDate
          Else
               MsgBox "Please re-enter your date!", vbExclamation, "Wrong Format"
          End If
     End If

          Range("Koment").Value = strDate

End Sub

Main   +       

2007