Combo Boxes

ChrisAnnable
ChrisAnnable used Ask the Experts™
on
I've got 6 combo boxes, when one of the top three are changed, i want the bottom three to be disabled, but if one of the bottom three are changed i want the top three to be disabled. How can i do this?

Chris
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Private Sub combobox1_change()
  combobox2.enabled = false
  combobox3.enabled = false
  combobox4.enabled = false
end sub

Private Sub combobox2_Change()
  combobox1.enabled = false
...

end sub

and so on

Author

Commented:
Can i make it change the combo box list values?

Chris

Commented:
combobox2 = "YourValue"

and so.....

Author

Commented:
can i change say the 15th item on a combo box, or delete, or insert for that matter.

Thankyou

Chris
combobox2.additem "bob",14 'it starts at 0, so the 15th item is 14
combobox2.removeitem (14) will take it completely away

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial