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!") |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need advice on 0, "" , " "
you can use this to detect a variable amount of spaces.
if qty = Space(Len(qty)) is your part number all numeric? is there a way you can check a list to see if it matches and return an error if it doesn't? HTH Die_Another_Day AskExcel wrote: 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!") |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
need advice on 0, "" , " "
Hello,
I suggest you could use function TRIM(text). TRIM() could get rid of the space on both sides and keep one space between two words.If you define variable as string, you can do as follows: if trim(qty)="" or trim(qty) = "0" then .... Hope it works! Viesta Shanghai, CN "AskExcel" wrote: 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!") |
Reply |
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) |