#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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] |
#3
|
|||
|
|||
Quote:
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) |
#4
|
||||
|
||||
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.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thank-you so much!
Quote:
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! |
#6
|
||||
|
||||
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] |
#7
|
|||
|
|||
That did it!
Thank-you very much! My template is now perfect! Thank-you, thank-you, thank-you!
|
|
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 |
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 |
Having problems with Duration calculations. | bgane | Project | 1 | 03-20-2006 06:36 AM |