Date excel userform's textbox

Closed

AKS - Aug 14, 2010 at 06:03 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:36 PM

Hello,
i have a problem in excel userform's textbox(txtDateofBirth)
if date of birth is between 01/01/1981 to 01/01/1991 then msgbox show "Adult"
and if date of birth is before 01/01/1981 then msgbox show "Too Old" & after 01/01/1991 then then msgbox show "Too Young"

can anyone solve my problem please.

AKS

Excel userform textbox date format dd/mm/yyyy
Dd-mm-yyyy format in excel - Guide
Format factory - Download - Other
Transfer data from one excel worksheet to another automatically - Guide
Number to words in excel - Guide
Kernel for excel - Download - Backup and recovery

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Aug 17, 2010 at 11:36 PM

see this

https://ccm.net/forum/affich-434574-textbox-date-value-max#19

Similar discussions

How to use conditional format based on text?

Excel date format won't change

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!