Hi,
I would like textbox two to calculate the value of textbox one (date of birth i.e. 19/03/1976), using this forumla:
Can you explain how I can do this using code please?![]()
Please Login or Register to view this content.
Thank you in advance
Hi,
I would like textbox two to calculate the value of textbox one (date of birth i.e. 19/03/1976), using this forumla:
Can you explain how I can do this using code please?![]()
Please Login or Register to view this content.
Thank you in advance
You will have to test this, TextBox2 must contian a proper data
![]()
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank s for the quick reply.
I added it to the textbox1 change event when I entered "/" for example 21/ it came up with an error. Where should the code reside?
The error states run time error 13 type mismatch.
I placed it here:
Thank you in advance.![]()
Please Login or Register to view this content.
Run it in the Exit event, not the Change event.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks