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

Risk Rating.docm (32.2 KB, 9 views)

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]

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.