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!")