Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-19-2011, 03:08 PM
Jennifer_Falcon Jennifer_Falcon is offline Perform Calculations using List boxes Windows XP Perform Calculations using List boxes Office 2003
Novice
Perform Calculations using List boxes
 
Join Date: Jul 2011
Posts: 4
Jennifer_Falcon is on a distinguished road
Default Perform Calculations using List boxes

Good Day,

I am new to programming / designing forms in Microsoft Word. I am using Word 2003.

I have been asked to make a template for our change management system.

What I would like to do is this:

Column 1 --> Question to ask User
Column 2 --> Choice of Answers for User

Column 1 Column 2
Is the implementation date within the change window? List Box with options: Yes, No
How many services are affected by this change? List box with options: 1 to 3, 4 to 6, 7 to 9
How technically complex is the change? List box with options: Extremely, Very, Minimal, Low


I want to be able to calculate the risk of this change. The risk is determined by the weight of each answer in the list box.

So, if you chose these options:

Column 1 Column 2
Is the implementation date within the change window? Yes (worth 5 points)
How many services are affected by this change? 1 to 3 (worth 8 points)
How technically complex is the change? Extremely (worth 10 points)

The risk would be 23 ( 5 + 8 + 10)



I would then like the Risk amount to be displayed in a field. If the user changes their answers, the total should should update.

Is this something that is easy to do in Word?

Thanks,

Jennifer
Reply With Quote
  #2  
Old 07-19-2011, 06:42 PM
macropod's Avatar
macropod macropod is offline Perform Calculations using List boxes Windows 7 64bit Perform Calculations using List boxes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Jennifer,

Creating such a form in Word is fairly easy. For what you've described, a series of dropdown formfields would be suitable for gathering the data. For the calculations, a macro would be required.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 07-20-2011, 02:31 PM
Jennifer_Falcon Jennifer_Falcon is offline Perform Calculations using List boxes Windows XP Perform Calculations using List boxes Office 2003
Novice
Perform Calculations using List boxes
 
Join Date: Jul 2011
Posts: 4
Jennifer_Falcon is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
Hi Jennifer,

Creating such a form in Word is fairly easy. For what you've described, a series of dropdown formfields would be suitable for gathering the data. For the calculations, a macro would be required.
Hi there, thank-you for your response!

I had wondered if a macro would work, but I don't know where to start on creating (I know how to create macros, but I don't know what coding I would use)
Reply With Quote
  #4  
Old 07-21-2011, 01:11 AM
macropod's Avatar
macropod macropod is offline Perform Calculations using List boxes Windows 7 64bit Perform Calculations using List boxes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Jennifer,

See the attached for an idea of what can be done.

I've used a set of dropdown formfields that trigger a 'calculate' macro whenever you tab out of any of the formfields.
Attached Files
File Type: doc Risk Assessment.doc (54.0 KB, 42 views)
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 07-25-2011, 11:05 AM
Jennifer_Falcon Jennifer_Falcon is offline Perform Calculations using List boxes Windows XP Perform Calculations using List boxes Office 2003
Novice
Perform Calculations using List boxes
 
Join Date: Jul 2011
Posts: 4
Jennifer_Falcon is on a distinguished road
Default Thank-you so much!

Quote:
Originally Posted by macropod View Post
Hi Jennifer,

See the attached for an idea of what can be done.

I've used a set of dropdown formfields that trigger a 'calculate' macro whenever you tab out of any of the formfields.

Hi there,

Thank-you for your fine example. From your document, I was able to get my multi-table questions set up the way I want to. There are truly some gifted people out there who make this stuff look so easy!

If I am not imposing, I am wondering if you could help tweak my document a bit more.

I would like to add further information in my document. In fact, the risk assessment questions are going to be located further in my document. When I go to add more information into my document, I get the error: Run-time error '5941': The requested member of the collection does not exist."

I got the error when I added a page break to my document.

I have included the document as I would "like it" to appear.

I don't know how to add the page breaks without wrecking the calculations in the table. There will be many other tables in my document as well.

Again, thank-you for your assistance so far. I am very grateful!
Attached Files
File Type: doc Risk Assessment 7.doc (76.0 KB, 18 views)
Reply With Quote
  #6  
Old 07-25-2011, 07:56 PM
macropod's Avatar
macropod macropod is offline Perform Calculations using List boxes Windows 7 64bit Perform Calculations using List boxes Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Hi Jennifer,

Add a bookmark named 'RiskTable' to the risk assessment table and change:
With ActiveDocument.Tables(1).Range
to:
With ActiveDocument.Bookmarks("RiskTable").Range.Tables (1).Range
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 07-26-2011, 10:49 AM
Jennifer_Falcon Jennifer_Falcon is offline Perform Calculations using List boxes Windows XP Perform Calculations using List boxes Office 2003
Novice
Perform Calculations using List boxes
 
Join Date: Jul 2011
Posts: 4
Jennifer_Falcon is on a distinguished road
Default That did it!

Thank-you very much! My template is now perfect! Thank-you, thank-you, thank-you!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Ho to perform multi selection in drop down lists? nashville Word 0 09-29-2010 07:10 AM
Calculations using values from date picker controls Inkarnate Word 0 06-09-2010 07:16 AM
Perform Calculations using List boxes Can I do calculations with times? cubsfan_1 Excel 1 01-14-2010 06:55 PM
Problem with Developer Form -- Check Boxes and Text Boxes PCC Word 1 05-16-2009 05:22 AM
Perform Calculations using List boxes Having problems with Duration calculations. bgane Project 1 03-20-2006 06:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:10 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft