Hello,
I have created a user form for registrating Swimming Lessons patrons. I have a created a DTpicker drop down for entering the Date of Birth for each child.
I have created a text box for the Age, but I would like the Age to be auto-populated within the userform, once the D.O.B is entered. Is this do-able?
Thank you so much.
Yes it is.
You shall use exit event of DTpicker and write calculated age on a basis of seleted DOB date into your textbox,
Best Regards,
Kaper
You could use DateDiff.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Thanks so much for your prompt responses. I am still a bit confused. I have attached a sample of my work book. If you open the userform you will see there are input sections for 3 different children.
Try this.
Please Login or Register to view this content.
Perfect!!! Thanks so much! Works like a charm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks