I'm wondering how I can Check for duplicates in a listbox. The listbo
is filled with values from a combobox and has numbers 1000 -8000.
need to say ok, You've already entered a value for 1000 please chec
the posting code and try again.


I was trying something like


Code
-------------------
if userform2.listbox1.value = userform2.combobox1.value then
msgbox "im sorry you've entered duplicate charges"
else
with userform2.listbox1
.additem userform2.combobox1.value
end wit
-------------------


Its a little more complicated then that but this is just a relativ
idea of what im trying to do.

Thanks in advance...
Chris :cool

--
justchri
-----------------------------------------------------------------------
justchris's Profile: http://www.excelforum.com/member.php...nfo&userid=889
View this thread: http://www.excelforum.com/showthread.php?threadid=40139