Compare with Date TODAY function, and have resulted in year to DateDiff Via VBA

Hi.
I'd like your help to do the following.
I have two TextBox. The TextBox1, I enter a date (dd / mm / yyyy) in TextBox2 I would like the results as "Y", starting from today.

example:
TextBox1 = 30/05/1990 TextBox2= 22


I tried it but did not work!

Please Login or Register  to view this content.

if someone could help me will be grateful!

Thank you!

The Change event evaluates each keystroke so you will need to use an event to do the calculation "after the date has completely been entered". I used the "LostFocus" event in the code snippet below. After you change textbox1 with the date, click anywhere outside the box and textbox2 will calculate to the difference in Years between now and the date entered in Textbox 1

note that you could use a button to trigger the calculation as well....

Please Login or Register  to view this content.

Enjoy!

Hi.
Thank you!!!

was great!!

Thank you!!!

I wonder if you can do this without using a CommandButton?
after digitarr date in textbox1, the move to textbox2, cóodigo run, is this possible?

Hi
Any idea?
wonder if you can do this without using a CommandButton?
after digitarr date in textbox1, the move to textbox2, cóodigo run, is this possible?

There would be no easy way to do that without very advanced programming to create your event.

The easiest way without a command button I can think of is processing when you hit the Enter Key after typing in your date.

Please Login or Register  to view this content.

was great, thanks!