combobox values

[Greg]

Hi,
I have a userform with 10 comboboxes on it how do I use excel to check the
value of the other boxes on the form. so I do have not any duplicates of
items.

Thanks

Greg

 

[Rick Hansen]

Greg, Here is some pseudo code that should get your started..

enjoy, Rick

Dim x as Integer, y as Integer

for x = 1 to 9
for y = x+1 to 10
if Me.CompoBox & x = Me.CompoBox & y then
MsgBox("Duplicate Found")
Exit For
endif
next y
next x

 

[Greg]

Thank you Rick

Greg

Greg, Here is some pseudo code that should get your started..

enjoy, Rick

Dim x as Integer, y as Integer

for x = 1 to 9
for y = x+1 to 10
if Me.CompoBox & x = Me.CompoBox & y then
MsgBox("Duplicate Found")
Exit For
endif
next y
next x