View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anniem Anniem is offline
external usenet poster
 
Posts: 11
Default 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!