Generate content in 3rd cell from drop down lists in 2 other cells
I made the current VBA code (see attached) using Macropod’s excellent example for conditional formatting (the colors are defaults).
With a single parameter (manually cross reference the x and y labels to determine your risk rating) it’s a bit redundant.
What I would like to do is have a combobox drop down selection in the Likelihood and Impact cells that would then generate the matching risk rating in the Risk rating cell.
This would reduce the drop down list items from 26 to 2 lists of 5 and would be a cooler use of the automation.
Help me Obimacropod, you’re my only hope!
|