|
Posted to microsoft.public.excel.programming
|
|
|
Combobox Query
Thanks for that
Greg
"C01d" wrote in message
...
I assume that your code does not give special treatment to blank cells.
When left blank, your code detects two empty strings and finds that
they are the same. Hence it executes the code for duplicates.
If you want to disallow blank inputs, simply check for that first and
exit from the code if any blank inputs are found.
If you want to check for duplicates while ignoring blank cells you can
use the following condition when comparing two values:
if(c1.value<"" and c2.value<"" and c1.value=c2.value) then
execute code for duplicates
endif
--
C01d
------------------------------------------------------------------------
C01d's Profile:
http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=544149
|