cwunderlich
07-14-2010, 09:17 AM
This seems very simple, but it has been a while since I have done VBA stuff, and even then I never really dealt with text boxes...
But here is what I need, any help would be greatly appreciated:
There is a text box (within excel) that the user fills in with the current date and another text box that they fill in with their Date of Birth. I am trying to write a macro that stores these values in two variables and then calculates the age of the person using the two dates (i.e. [currentdate - dob]/365 )
when I used user forms in the past this was no problem, but it does not seem to be working with text boxes...
Thanks again for any help!
But here is what I need, any help would be greatly appreciated:
There is a text box (within excel) that the user fills in with the current date and another text box that they fill in with their Date of Birth. I am trying to write a macro that stores these values in two variables and then calculates the age of the person using the two dates (i.e. [currentdate - dob]/365 )
when I used user forms in the past this was no problem, but it does not seem to be working with text boxes...
Thanks again for any help!