snuggles79
New Member
- Joined
- Sep 25, 2006
- Messages
- 8
Yesterday my code in excel was working perfectly and today I am getting a "Cannot Find Project Or Library" error message and it's highlighting the phrase "Format" in particular
The code is:
Anybody know how to sort this problem out?
Thanks in advance
The code is:
Code:
Private Sub contdate_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Not IsDate(contdate) Then
MsgBox "Input must be a date in the format: 'dd/mm/yyyy'"
Cancel = True
Else
contdate = Format(contdate, "dd/mm/yyyy")
End If
End Sub
Private Sub conttime_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If Not IsDate(conttime) Then
MsgBox "Input must be a time in the format: 'hh:mm'"
Cancel = True
Else
conttime = Format(conttime, "hh:mm")
End If
End Sub
Anybody know how to sort this problem out?
Thanks in advance