Loop with And

cmdPassNum.value is a textbox on my userform.

Basically the value entered in there will always be between 1 - 5 and the value in column F will also be between 1 - 5.