Unique username

[Gourav]

Hi,

i have created a register userform which has a name, login id and password text fields.
I am passing my login id / username to the first column of sheet2 which is hidden.
Now, these are the constraint i want to put

I want to put a constraint that whenever someone is using a username to register, the same username shouldnot be already be present in the first column of sheet2 i.e. it should be a unique username.
Also, i want to put a constraint on password as well as username, that it cannot have spaces.
Also, that all these three fields cannot be null.

All the help is greatly appreciated as i am quite new to the vba excel and your viewpoints will defiitely help me learn the subject.

[kvsrinivasamurthy]

Pl see attached file.