Enable/Disable ComboBox
Hi All,
I am way out of my depth here and appreciate any help you can give.
I have a worksheet with 4 Combo Boxes but would like to disable either the
3rd and/or 4th depending on the contents of a particular cell. ie. If A1 =
"2" only ComboBox1 and ComboBox2 enabled. If A1 = "3" then the 1st 3
ComboBoxes enabled (or ComboBox4 disabled) etc etc.
Can this be done and if so could someone please tell me how?
Many thanks!
|