Problem whil e Auto Populate

[Mangesh Shinde]

Dear Sir,

I have prepared Excel sheet wherein 1 userform for Login to Excel sheet and 2 userform to calculation.

If Username and password mentioned wrongly then it directly goes to Userform2 which i dont want.

If username and password wrong then next userform should not open.

I am not able to fix this problem.

Can you please help me.

Attached sheet have usename and password as below

Username - myuser
Password - mypassword

Regards,
Mangesh Shinde

[gmr4evr1]

Mangesh,
I added the code below to your code for UserForm1 after the MsgBox "You Entered wrong password/username" line

Please Login or Register  to view this content.

So now your code becomes

Please Login or Register  to view this content.

[Mangesh Shinde]

How much brilliant you are.

Again Thanks alot for your constant support.

Regards,
Mangesh.

[gmr4evr1]

You are welcome