Vba Login Form Code. This will create a new user form like the below one. Be sure design mode is selected on the insert tab click new user form.
In the assorted macros module add this code. Everytime you load the login form login id and password are cleared. If designing a separate form or applying the code to an existing form change the names of the objects as needed.
Right click commandbutton1 and click view code.
Login button to verify password and navigate to the next page. To do that just click on developer tab then click on visual basic icon available in code group. Vba visual basic for applications allows users of microsoft applications to create custom code and utilise it to perform actions otherwise not included. Open visual basic window.
