how to create a vba login form in excel vba

This video covers How To Create A Login Form In Excel VBA.
Excel VBA book (affiliate) with reviews https://amzn.to/3axlqih

I go into detail on VBA login form design in this tutorial covering both the design and coding of a user form in Excel VBA.
I use an Object-Oriented programming methodology here which is the best way to code an excel form if you wish to query the form to retrieve information from the form while it's running.
Blog post to go with this video is at ..
https://www.businessprogrammer.com/how-to-create-excel-vba-login-form/
This video covers designing the form, adding two VBA textboxes for username and password and two VBA command buttons for cancel and login.
Then we go into the code behind the form which covers using object orientation to set custom properties of the VBA login form.
Next we insert a standard module in the vba ide and add the code to call the form.
The excel vba login application covers a complete application that allows users to distribute a custom app to different departments to for example gather consolidation information.
Enjoy.

☕
If you found this tutorial helpful consider supporting this channel with a steaming hot cup of coffee...https://www.buymeacoffee.com/seanjohnson
☕

Video Production
===============
Sony Camera: https://amzn.to/3mqyqfu
Elgato HDMI Stream Capture: https://amzn.to/2Yfyrum

Microphones
---------------
Screen Casting: https://amzn.to/3a2TnHN
Microphone and Arm : https://amzn.to/3iwvL2S
Talking To Camera: https://amzn.to/3FqXI6b

Video Kit
-------------
Lights
Elgato video Lights: https://amzn.to/3sSK3xg
Background Light: https://amzn.to/3uTXyPh

Note Taking
--------------
Rocketbook reusable notebook https://amzn.to/3sSK3xg

#excelvba #excelmacro

DISCLAIMER: This video and description contain affiliate links, this means if you click on one of the product links, I’ll receive a small commission.
If you do use one of the links, thanks I appreciate it.

Видео how to create a vba login form in excel vba канала Sean Johnson