Avatar of K Tin
K TinFlag for United States of America

asked on 

Calculate age in Microsoft Word

I am wanting to calculate age on a form document in word. I just need a easy to follow macro (I'm a newb to this).
Microsoft OfficeVB ScriptMicrosoft WordVBA

Avatar of undefined
Last Comment
Shums Faruk
Avatar of Shums Faruk
Shums Faruk
Flag of India image

I am not sure which form field you have, you'll need to do the work yourself. To help you get started, check below link:
How Can I Put Calculated Dates in Word?

Take a look and let me know what additional questions you have.
ASKER CERTIFIED SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of K Tin
K Tin
Flag of United States of America image

ASKER

Sorry I'm dense... so do I click Ctrl-F9 and name, within the brackets, {CalcAge} or {MACROBUTTON CalcAge}
Avatar of Shums Faruk
Shums Faruk
Flag of India image

If you already have Data Field as above then you just run Macro CalcAge
Avatar of K Tin
K Tin
Flag of United States of America image

ASKER

When I try to run the Macro I get an error "Run time error 5941 the requested member of the collection does not exist"
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Please upload your sample document.
Avatar of K Tin
K Tin
Flag of United States of America image

ASKER

Uploaded
test.docm
Avatar of Shums Faruk
Shums Faruk
Flag of India image

There is problem in your template. Let me make new one. Give me some time
SOLUTION
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Avatar of Shums Faruk
Shums Faruk
Flag of India image

Kindly note you need to double click on DOB Field and change the date in Default Date then run macro
Microsoft Office
Microsoft Office

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

80K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo