Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,616
- Office Version
- 365
- 2016
- Platform
- Windows
Perhaps I'm using cdate incorrectly. I wish to take the text date from a userform control ("processdate") and convert it to date serial.
My code:
I am getting a 'type mismatch' error with the line in red.
Is it my textual representation of the date which is complicating things?
Rich (BB code):
me.processdate.value="Tuesday, January 23, 2018"
My code:
Rich (BB code):
Private Sub Label834_Click()
Dim uid
uid = CDate(processdate.Value)
End Sub
I am getting a 'type mismatch' error with the line in red.
Is it my textual representation of the date which is complicating things?