I have list of four Options in a user form that are for the most part "grayed
out" When a condition is met those Options become enabled. I am trying to
use a single ComboBox to indicate how many pieces of that product can be
used. Is there a way to make a single ComboBox work for the four Options or
do I have to create four ComboBoxes and link them to each Option. Another
way I thought of doing it is by setting the ControlSource to be something
like L209 and writing a formula in the worksheet to use L209 in a If
statement, but that seems like an extra step that may not be needed. Any
Ideas on how to go about this would be much appreciated.
Thanks for everyones help so far.