Hello All,
I am trying to get this cell formula converted to VBA to work on a userform I am putting together.
$B5 is now a TextBox named "tbdob" and I am wanting the calculation to display in another TextBox named "tbage" after "tbdob" has exit.![]()
=DATEDIF($B5,NOW(),"Y")&" Years, "&DATEDIF(B5,NOW(),"YM")& " Months, "&DATEDIF(B5,NOW(),"MD")&" Days"
I am not quite sure how to change this over.
Your help is appreciated, please and thank you.
Patrick
Bookmarks