View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AskExcel AskExcel is offline
external usenet poster
 
Posts: 19
Default 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!")