Coding for Submit Button

[Shweta]

Hi All,

I have created a userform in VBA for user ID and password.
I placed a commandbutton on my excel sheet when a user click on this commandbutton, a userform will get opened where he needs to enter his user Id and password and press the submit button and only after that he will be able to see the excel sheet data.

Now I am not getting what should be the coding for submit button.

Please help me out

Thanks
Shweta

 

[Ruddles]

Right-click the submit button on the userform in design mode and View Code.

 

[Shweta]

Thanks Ruddle but my question is what should be the coding for submit button so that an user can view the data on excel.

 

[wigi]

You might direct the user from a sheet that everyone can see, to a sheet you can only see after the successful login.

 

[Ruddles]

Why are you asking the user to enter his userid and password in a userform? Didn't he do that already when he logged in to Windows?