Dependant Command Box

[mhudsora]

Hello all,
Simple example:

• I have two command boxes on a userform
• I have populated those command boxes with the value: "apples" and "oranges"
• The user selects "apples" in the first command box
• How do i remove the value "apples" from the second command box?

Thanks!
mhudsora

 

[mhudsora]

Getting weird runtime error from code that should work:

For x = 0 To (ufEditValue.cbValue1.ListCount - 1)

If ufEditValue.cbValue1.List(x) = ufEditValue.cbValue2 Then ufEditValue.cbValue1.RemoveItem (x): Exit For
​

Next x

Runtime error is as follows:

Excel run-time error '-2147467259(80004005)'
Unspecified error

​

Any help would be great, Thanks!