How to Create a Modern Login Page in VBA (Step-by-Step)

[@liquidapathy82]

Absolutely stunning video

[@YourVBTutor]

Thank you very much! 🙂

[@mixeflixin]

Great take on an old architecture. Would be nice to a see follow up video showing how make a modern, dynamic form.

[@YourVBTutor]

Thanks for watching 🙂

[@albertloua2627]

Amazing, great video! Thanks

[@YourVBTutor]

Glad you liked it! Thanks for watching 🙂

[@drfailbucket]

I do really like the approach with the class modules 👍 i definitely should learn more about them 🤝

[@YourVBTutor]

Class modules are really fantastic ways to clean up your code and build things dynamically. There's certainly a lot to learn about them. Thanks for watching! 😊

[@tomshaw9065]

A very interesting presentation - introduced a few ideas I have seen mentioned but never seen developed. I would be interested in a session of completing the login process in a workbook. Now back to stepping through the video - slowly!

[@YourVBTutor]

Yes, absolutely, I think that'll be the next video. Thanks for watching 🙂

[@chrisouellet2832]

You are a VBA GOD!! thanks for these tips - creating a modern look had always eluded me until this vid! : ) keep your knowledge flowing to the laymen (me!)

[@YourVBTutor]

Thank you! Will do! 🙂

[@richardhainsworth9428]

Would love to see the fully functional log in form. Would also be great if you could build in an annual subscription reminder in this so that it cannot be used beyond a specified date but can be renewed once payment received. Loving your videos!

[@YourVBTutor]

I also have a system for licencing, integrating with an online licence manager. I may make a video on that in the future. Thanks for watching! 🙂

[@EzrielMangui]

Gonna add this to my Excel project

[@YourVBTutor]

Glad you enjoyed. Thanks for watching! 🙂

[@truthseeker9988]

👍👍

[@Dexter101x]

That's what I was thinking, Microsoft hasn't exactly updated the user form since its inception. And thanks to your videos, I think that I am using PowerPoint a lot more

[@YourVBTutor]

VB. Net has come a long way, but VBA (VB 6.0) hasn't had any significant update to the userforms in probably 20 years. But that doesn't mean that you can't make it look good! Thanks for watching 😊

[@michaelmd3541]

Great work. Very nice and beautiful. Very much interested in the actual vba login.

[@YourVBTutor]

Thanks very much. If there's enough interest then I will make that my next video. 😊

[@Dexter101x]

@@YourVBTutor Of course, would love that

[@drfailbucket]

@@YourVBTutor im curious about the logic behind the passwod forget section. How to handle the 'codes send by email' thing works 🤔

[@YourVBTutor]

I've built this into some of the applications and projects I've built. It's actually great fun to play with (if you're a nerd like me 🤓)

[@michaelmd3541]

@@YourVBTutor would love to see that

[@jovke79]

Wow, very nice! Defiantly would be great to se full logic with VBA login.

[@YourVBTutor]

Good to hear you're interested. Thanks for watching 🙂

[@CoderzF1]

well, if you have visual basic 6.0, you could likely create a custom control.... only issue with this is that the ocx would have to be distributed with the excel sheet

[@CoderzF1]

I do wish microsoft would add proper mouse enter and mouse exit for controls on a userform and mouse effects for the spreadsheet so you can have hover effects for shapes.

[@CoderzF1]

I've used VBA since 2001 and have always wondered why there were some events missing that can be found in visual basic 6.0

[@YourVBTutor]

I absolutely agree. There are so many features that should be in excel that seem like obvious additions to us, but Microsoft aren't implementing. Hopefully one day we can get them. Mouse events for shapes would be huge. Thanks for watching 🙂

[@muhammadkausar2842]

Sir please can u make a video on how to find the exact left and top position of mouse cursor. For example when we right click on any cell, then you may notice all the right click options are pop up with mouse cursor. I want this for to pop up the userform where my mouse cursor is. Please and also work for every type of screen size of laptop or desktop. I try some window API but didn't get perfect result. Thank you sir ❤

[@YourVBTutor]

Loading the position of userforms relative to the screen can be really tricky. I've done this a few times and I plan to make a video on creating custom drop-down menus, which uses this concept. So keep an eye out for that one in the future. Thanks for watching! 😊

[@muhammadkausar2842]

@YourVBTutor showing Userform1 on Userform2 is easy by using there mouse move event. And Userform2 will Pop up with exact mouse cursor. But if we want to open Userform1 on Workbook Open event and where ever is our mouse cursor, Userform1 should pop up there. This is challenging. But I will wait for your video sir. Thank you for amazing content ❤️