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

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" wrote in message
...
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

Thank you Rick

Greg
"Rick Hansen" wrote in message
...
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" wrote in message
...
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