| Home |
| Search |
| Today's Posts |
|
|
|
#1
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combobox query? | Excel Programming | |||
| ComboBox Filled by Query | Excel Programming | |||
| Combobox query | Excel Discussion (Misc queries) | |||
| Tricky ComboBox / Filter query | Excel Discussion (Misc queries) | |||
| Combobox Query | Excel Programming | |||
![Greg[_27_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
