![]() |
Linking a ComboBox
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. |
All times are GMT +1. The time now is 07:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com