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)