Hello All,

I am trying to get this cell formula converted to VBA to work on a userform I am putting together.

=DATEDIF($B5,NOW(),"Y")&" Years, "&DATEDIF(B5,NOW(),"YM")&
" Months, "&DATEDIF(B5,NOW(),"MD")&" Days"
$B5 is now a TextBox named "tbdob" and I am wanting the calculation to display in another TextBox named "tbage" after "tbdob" has exit.

I am not quite sure how to change this over.

Your help is appreciated, please and thank you.

Patrick