| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need advice on 0, "" , " "
Hi All,
I do not know what is the best way for the below syntax. Any better function instead of using 0, "" or " " although it can work. Now I afraid if user enter " " which is 2 spaces then the program unable to detect. Need the advice. Thanks If qty = 0 Or qty = " " Or qty = "" _ Or item = " " Or item = "" Then MsgBox ("Part Number and Quantity Must Input!") |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spell check: advise and advice are used in the wrong context. | Excel Discussion (Misc queries) | |||
| Advice on how to automate | Links and Linking in Excel | |||
| Importing data, and need formatting advice | Excel Worksheet Functions | |||
| Excel Application Development Costs - Need Advice | Excel Discussion (Misc queries) | |||
| building invoice - strategy advice | Excel Discussion (Misc queries) | |||
Threaded Mode
