#1
|
|||
|
|||
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! |
#2
|
||||
|
||||
Try the attached.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Thanks macropod!
I shall name my ... 3rd born? in your honour. |
Tags |
dropdownlist, macropod, vba |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Drop down lists and pulling data from worksheet based on drop down selection | cjoyce73 | Excel | 5 | 07-17-2017 07:40 AM |
using styles to generate content page | TYPO | Word | 2 | 12-20-2015 12:48 PM |
Link multiple cells in drop-down lists | Trial4life | Excel | 0 | 09-08-2014 05:08 AM |
Chosen option of drop-down changes another cell content | Weed | Word | 1 | 01-26-2012 02:44 PM |
Using both drop down lists and blank cells for text | voltarei | Word | 0 | 03-18-2010 04:16 AM |