Userform - Lock-out value from drop down list of combobox

[Villalobos]

Hello,

I would like to ask that how is it possible to lock-out those values from the drop down list of ComboBox which has been selected in one of ComboBoxes already. I mean that: I have 3 ComboBox on userform and If I select "John Doe" in Combobox1 then I wouldn't like to see this name in the drop down list of Combobox2 and 3.

I have attached my sample file.



Thanks in advance the reply!

 

[Luke M]

Check out this similar tutorial on hiding previous values. Tutorial uses Data Valdation, but you could do the same thing with the linked range in a ComboBox
http://www.contextures.com/xlDataVal03.html

 

[Villalobos]

Hi Luke M,

Thank you the link, but unfortunately I can not do this in VBA environment.

 

[Luke M]

Check out this example.

 

[Villalobos]

Hi Luke M,

Thank you the help!