C
Cerberus
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.
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.