Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a userform where the user will input their birthdate. I used the
IsDate function to make sure they enter a valid date. I would like to add code to catch dates that are in the future (e.g., "If txtBirthdate.Value Today Then..."). This is the code I have so far: Private Sub txtBirthdate_Exit(ByVal Cancel As MSForms.ReturnBoolean) If txtBirthdate = vbNullString Then Exit Sub If Not IsDate(txtBirthdate) Then MsgBox "That is not a valid birthdate." Cancel = True End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
save as future date eg expected delivery date | Excel Discussion (Misc queries) | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
date in the future | New Users to Excel | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |