Constant code interruption...

[RayJay01]

I have created a UserForm that allows people to log-in to my worksheet -using stored information in A:A(username) and B:B (password).

On the same sheet, I have a cell in which I would like the UserForm to paste the "Username" entry of the form into Cell J2 (this will be used to check the current user logged in). It's really frustrating as I have found the route cause, and tried many different scenarios, to no avail.

My full code is below, the highlighted range (red) seems to be the thing causing all of these problems. I can run the code once (on occasion twice) before it takes me to the VBE and highlights the "Private Sub LogInButton_Click() UserLogIn.Show part, with a message saying the code had been interrupted.

as soon as you remove it from the code it works perfectly. Is there a way around this?

UserForm Code

Please Login or Register  to view this content.

Sheet Code

Please Login or Register  to view this content.

[JosephP]

what if you don't activate the other sheet but qualify your range statements instead? ie use sheets("login").range(...) rather than just Range(...)