Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-18-2019, 04:26 PM
JNMBeaudesert JNMBeaudesert is offline Calculated field using Content Control Dropdowns Windows 10 Calculated field using Content Control Dropdowns Office 2016
Novice
Calculated field using Content Control Dropdowns
 
Join Date: Dec 2019
Posts: 2
JNMBeaudesert is on a distinguished road
Question Calculated field using Content Control Dropdowns

Hi All,



I need a little help trying to get a field to auto populate according to selections made from 2 dropdowns. These results correlate to a risk matrix resulting in a rating of Low to Extreme. I've attached the file for reference.

The hope is to not use macro/VBA coding if possible but I have started working on code in order to achieve it which you'll find in the document and have just focused on trying to get a single selection working first. The problem is that VBA is not my strong suit and my coding likely reflects that. Regardless of the choice I make I only ever get the highest rating (last option) populating the field. I know this is due to the line "Consequence = .DropdownListEntries(i).Value" as this will always be 4 resulting in Extreme but I can't not have the (i) so I'm lost.

The goal is that you make your selections from the Consequence and Likelihood dropdowns and the Risk Rating is auto populated with the corresponding rating from the matrix.

In the end I was going to have a variable field for Consequence and Likelihood then set the rating according to the sum of the values, i.e. 1+1 is top left rating resulting in medium. Obviously given there are to sets of dropdowns, there would be 2 subs with naming of fields and so forth.

Thanks in advance for the help so close to Christmas.

Regards,

JNMBeaudesert
Attached Files
File Type: docm Risk Rating.docm (32.2 KB, 7 views)
Reply With Quote
  #2  
Old 12-18-2019, 09:22 PM
macropod's Avatar
macropod macropod is offline Calculated field using Content Control Dropdowns Windows 7 64bit Calculated field using Content Control Dropdowns 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

I don't think you'll be able to do this without a macro - which could reside in your risk rating document's template rather than the document itself. That way, you could employ the docx format, rather than your present docm - which you only need if you're usinga macro stored in the document. See, for example: https://www.msofficeforums.com/130899-post6.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 12-19-2019, 12:11 AM
JNMBeaudesert JNMBeaudesert is offline Calculated field using Content Control Dropdowns Windows 10 Calculated field using Content Control Dropdowns Office 2016
Novice
Calculated field using Content Control Dropdowns
 
Join Date: Dec 2019
Posts: 2
JNMBeaudesert is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
I don't think you'll be able to do this without a macro - which could reside in your risk rating document's template rather than the document itself. That way, you could employ the docx format, rather than your present docm - which you only need if you're usinga macro stored in the document. See, for example: https://www.msofficeforums.com/130899-post6.html
This is doing pretty well exactly what I'm trying to do so thank you very much, I do appreciate it. I'll make the required modifications tomorrow and integrate into my document. I'll let you know how I go.
Reply With Quote
Reply

Tags
calculating values, content controls, macro automatic

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Content Control content deleted when re-uploading to SharePoint Peterson Word 5 06-27-2018 08:13 PM
Calculated field using Content Control Dropdowns One Content Control Checkbox checks another Content Control Checkbox DEsh Word VBA 2 10-06-2017 08:23 PM
Calculated field using Content Control Dropdowns Populate Content Control Dropdowns from Excel Deirdre Kelly Word VBA 23 09-07-2017 02:51 PM
Calculated field using Content Control Dropdowns Clicking the selected Content Control checkbox returns wrong control in vba event DougsGraphics Word VBA 2 06-24-2015 07:31 AM
Calculated field using Content Control Dropdowns Deleting a table from a content control -- preserving the content control BrainSlugs83 Word Tables 8 11-14-2013 03:06 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:26 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