Advanced Excel UserForm with real-life projects. Modern UI For beginners and professionals
ฝัง
- เผยแพร่เมื่อ 9 ต.ค. 2024
- This series covers how to design a Professional User Interface using Office Apps.
Subscribe, Like, and Comment. 🙏Thanks for watching.
You can now support by buying any of the Projects or Source Code.
📥Downloads: vbaa2z.blogspo...
👍 Support: paypal.me/pama...
✉️ Contact: vbaa2z.team@gmail.com
📌What to watch next:
Playlist: TH-cam.com/vbaa2z/pla...
Videos: TH-cam.com/vbaa2z/videos
#VbaA2z
My friend. You’ve created the perfect video for what I am looking for. I’m not even halfway through and you’ve already inspired me to upgrade almost every one of my projects. Thank you so much for providing such valuable content. Truly one of the best videos I’ve seen on this topic.
You're very welcome!
Never seen that much features in one teaching, amazing Pamai.
Thanks Ben!
Userform to SuperForm - This looks amazing! especially done from Excel VBA Userform. Great work!
Thanks a lot!
This video series is really phenomenal...it walked me through so many things I've wanted to incorporate since I started dabbling in dashboards for my job. Thank you so much!
You're so welcome!
Sir, this is the best userform series ever. I already watched them in prior publish and helped me in my projects. Many Thanks.
You are most welcome
Have to totally agree! Also following your process and approach was super helpful.
Sadly due to time constraints I haven't used all (yet! ^^)
Thank you for the guide that set the label invisible and then the textbox set focus. That's what i want! really appreciate!
Glad it helped!
Never learnt so much in one video. Thanks
Glad to help
most underrated channel. thank you for amazing tutorial!!!!
I appreciate that!
Simply "WOW", it's amazing. Thank you so much for sharing such kind of knowledge.
Glad you liked it! thanks for watching.
Thank you for this great tutorial. I just found your videos by coincidence and very happy about it.
Glad it was helpful!
Your lessons are so amazing, now I am grabbing on
Glad you like them!
Wow really amazing features. Will come back and watch more. Cheers 👍
Thanks for visiting
Wow... I learned so much. There are so many things here that I can use. Thanks!
You are so welcome!
excellent series. now to jump through the hoops to get the source code...
Thanks for supporting the channel. Much appreciated.
Amazing video, most in-depth and concise explanations out there! Keep up the awesome videos
Much appreciated!
Your videos have helped me complete my projects. Thank you so much
Glad I could help!
Interested to become VBA Pro? Here is 100% free guided e-course with Real-life projects. Sign-up to participate, get assignments and a certificate:- bit.ly/3eX8tzl
Wow 🤩 never such design and creativity
Thank you! Cheers!
This series is best of all. Super thanks
Thanks!
You taked the vba to another level 👏
Thanks!
Super Creative and Innovative!!!
Thank you! Cheers!
Just start to watch this amazing user form and subscribed your channel.
Thanks for the sharing
Welcome aboard! all the best.
Such a great video. Looking forward to completing my own project. Thanks!
You can do it! All the best!
Dear Friend,
This is amazing! Thanks a lot for the effort and sharing! NAMASTE 🙏
You are very welcome. Namaste 🙏
i love your videos especially on automation and dynamic designs
I appreciate that!
Wow this is amazing. Thanks for sharing your knowledge
My pleasure. thanks for watching
Keep sharing all these great contents!
More to come!
Your works are really amazing. Thank you Sir.
You are most welcome
this is absolutely brilliant. Thanks a million!!!!
You're very welcome!
Thanks for sharing and I really loved it.
Glad you enjoyed it!
loved this series. thanks again.
Glad you enjoyed it
0:00 - 31:27 : Log-in interface
32:35 - 1:12:55 : Special effects to controls and transition effects
1:13:20 - 1:33:40 :Record expenses
1:34:20 - 1:45:20 : Create new report
Thanks!
Thanks. I'd like to level-up my macro projects' design at work and this is very helpful.
Great to hear!
Its amazing, thanks so much for sharing
Glad you like it!
Great content! Looking forward to this series.
Glad to hear it!
Excellent user form programming. Please make a video on automating desktop application too.
Thanks for watching and for your suggestion.
This is amazing 😍
Keep it up
Thanks 😄
Nice work, the process to download the sample files is not easy though. But you are doing a neat job. it worth it
Thanks a lot!
This is great, thanks for sharing your knowledge 👍
Glad you enjoyed it!
Great job. My only comment is that you could slow down just a little bit. It is hard, sometimes, to see where you are clicking and the mouse is dashing all over the screen. This is only a small point though.
Cool video. Lots of stuff to learn !!
Glad you liked it!
Great tutorial.
Next, I will try it with Libreoffice Calc also.
thanks. all the best!
What a video man, Great job!
Glad you enjoyed it!
great work
Many many thanks
Thanks for sharing your amazing skills.
Thank you! Cheers!
Amazing tutorials and examples! Now I can see that forms are the field I need to improve my skills :)
Glad to hear, thanks for watching
i know Im kinda randomly asking but do anyone know a good site to watch new series online ?
@Lee Wesley Meh atm i have been using Flixportal. You can find it thru google :) -finn
@Finn Callan Thanks, signed up and it seems like a nice service :D I appreciate it!
@Lee Wesley No problem xD
Brilliant videos
thank you!!!
thank you so much for brilliant video
You're very welcome!
Best UI guide
Thanks Farhan!
I have a complex excel book which contains most of the functionality in spreadsheet coz I have to make it compatible with MAC also. Do you think Listview control can be a replacement of using a spreadsheet and can also work on MAC?
You are the ⭐start bro
Thank you bro!
Very professional video!👌
Thanks! 😃
Very creative ❤
Thank you! Cheers!
Awesome! Thanks so much
Our pleasure!
What a video man ! Amazing
Thanks a ton!
Fantastic!
Thank you! Cheers!
Very professional video!
Thank you!
Thanks for sharing. Will come back and finish later. Looks very promising.
Hope you enjoy it!
Great training resource
Thanks!
Very interesting video
Thanks
Glad you enjoyed it
I wish to use these User Interfaces and make my Excel Forms in a professional way. I hope these videos will be very much useful.
I hope so too!
Thank you so much. Great video!
You're very welcome!
Amazing
Thank you! Cheers!
Thanks Alot For This Aswome Tutorial
You're welcome!
superb, thank you
Welcome 😊
Very nice!
Thank you! Cheers!
For the beginning login module, do you as a designer to assign password for user? Or user will use the same Windows Login password?
How would you create a userform for a more complicated data stucture?
I am working with data where there are mutiple telephone numbers, customer notes, email addresses etc. So I have various tables that I need to pull/push data from/to.
Currently, I have temp tables where I store information that the user inputs/changes but it gets complicated when they hit save because I now need to either update or create new records depending on if the record(s) already exist. So before saving the temp data I will have to search for each record to see if it exists and then decide what to do with it...
Or, maybe I should keep a log in the temp table. e.g. whether the record needs to be created or updated.
Any thoughts?
Use Multi pages and tabs within multiples if you need to further segregate read / write
Hey, first I’d like to thank you for this video, I watched/referred this video so many times and it helped me a lot.
Now, I have a question: I’d like to keep a bunch of stuff in my userform (100s of frames, labels and other objects) which are overlapping on each other. So It’s becoming very difficult to work on those, is there a way we can hide/unhide the frames on the userfom ?? Because every frame I use covers the entire userform, and there are many objects inside each frame.
So I wanted hide all other frames except the one I’m working on, and again I’ll hide this and unhide another frame which I’ll work on and so on…
I’m not asking to hide/unhide these frames after running the VBA, I know how to do that. I want to know if it’s possible to hide while we are coding.
You're most welcome.
I am not aware of way to hide objects in Design mode. My practice is to move the UI controls off to the side, work with them there, and then position them during runtime or use multiple pages or multiple forms.
@@VBAA2Z Thank you so much for your response man, I appreciate it.
And yep that’s how I’m doing it but multi page doesn’t work for my case. Thanks 🙏 a lot
Im impressed!
thanks for watching Jesper.
You are amazing!
Thanks Krishna.
This is great. Can we create a form like this in word document too and update the documents with inputs from it and export the final doc to pdf? Kindly show some example.
Check this tutorial. it give you good idea on how to achieve what you're looking for.
and yes, you can also add / design UserForm in same fashion. All the best.
th-cam.com/video/RQgOxv6nrE0/w-d-xo.html
Thanks for this!
No worries!
Very useful, thank you
Glad it was helpful!
Very Very niceee man
Thank you so much 😀
What do u think about future of VBA. People say its a dying technology.
As long as Excel exist so will VBA :)
Learn multiple languages based on your requirements.
Hello Mr Lung, I kindly request you to make for me a video illustrating how to print multiple student's reports. I wish to make it like I can specify to print from report one to report number 50. Thanks
Ok I will try
@@VBAA2Z Dearly waiting for you my mentor.
Hey I really like all your work, it’s fantastic. Just wanted to give you my feedback, create the project , then focus on one object at a time and go through the code and show us how it works by testing it. Then next vid focus on the next object. just go into details rather then an overview.
Apart from that, fantastic work. Keep it up 👍🏼
Hi S A, Appreciate your feedback. Please check below link for all videos. The series cover design from both UI and UX perspectives however working with each control are covered in detail as you proceed.
th-cam.com/play/PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p.html
@@VBAA2Z thank you 😁
many thanks!
You're welcome!
Interesting videos my friend!
Many thanks
THIS IS GREAT
thanks!
How to make it dynamic when we want the forms to be used by others? Since you have kept all images in one folder it was easy. But what if we have to distribute the form for multiple user scenario? Thank you! I like the videos so far.
Google Drive Empresarial
Good
Thanks
This is really amazing. I'm a CS student diving to data analysis. Working on Sharpening my Excel skills. Your page is really amazing. Thanks so much for this. I'm having problem downloading the source code for this project,or is it not free anymore? I would really love to have the code to follow up efficiently. Please help with a link sir.
Awesome, thank you!
Please check vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
it is really amazing
thanks!
Thanks for video
Most welcome
Bravo
great video keep it up!
Thanks!
Thanks much sir.... Make flashing or blinking text in userform
thanks for suggestion. give this a shot. You can add GIF and make it flash.
th-cam.com/video/ck3NIB-TzR0/w-d-xo.html
Thanks for this video.
you are most welcome!
Hi mr
Nice work thank you very much
How can I show table inside userform and connect to table in excel sheet edit data like access form with table
Thank you very much
try ListBox or custom table. th-cam.com/video/JolVwS3emYg/w-d-xo.html
Thank you very much
But can I edit data inside this table
like access table inside form
Great video! I implemented the Userform LogIn! Despite the code snippet Apllication.Visible = False in the Workbook open event i see the excel sheets, before the Userform pops up, this defeats the purpose of a login windows. Do you know how to fix it?
If you're looking for standalone app try the .net series in the channel.
You can also use Access UI, Word UI etc.
@@VBAA2Z i do not want a standalone app, i just want to have a login userform for my excel. So when opening the excelfile only the login should appear.
Is this possible?
@@M1and5M Excel file will always load up first then your file which will trigger your code so there will be bit of gap before login form shows up.
nice
Thanks
Amazing thanks a million
You're welcome!
This is amazing staff. Where can I download the sample code and files?
pamaitech.com/downloads/
Muy bueno
thanks!
do you have sample video for userform that can upload excel list then it will appear to the excel worksheet of userform database? thanks in advanced if you have time for this question.
please check E2 of this series
th-cam.com/video/p93JRjTFWmc/w-d-xo.html
Awesome video.
Can you please work on batch. Random date and time (created,accessed,modified) changer for any files in batch mode via VBA.
Can you please work on it bro ?
Yes, sure
@@VBAA2Z can I ask till when will you upload the VBA code and it's tutorial ?
email me the details let me check.
@@VBAA2Z please check the below video fo your reference th-cam.com/video/WY0e1cWLv8Y/w-d-xo.html
Sir any update?
Did you watch that video?
Have you started working on random batch date and time changer for any files sir ?
Please reply .
Hi I got an error with your code saying "the code in this project must be updated for the use of 64 bit system". Could you please advise what could be wrong ? BTW, I'm using the most updated office 365
Please check this link. It'll guide you to update for 64-Bit Excel.
Note - > Date Picker and ListView won't work for 64-Bit Excel.
vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html
Is there a way to code where instead of going textbox1.value = cell (in excel) Like to be able to do programatically when adding or editing information in the sheet using the userform?
small example below.
textbox1.value = range("A1").value ' to fill textbox1 with cell value
range("A1").value = textbox1.value ' to fill cell with textbox1 value
@@VBAA2Z yes thanks. What I mean is like at the 50 minute mark you show that instead of doing a code for each image to create one called aImage to then modify each of the buttons. I was wondering if there was something similar to that when inputting or editing data in a userform. Instead of tEXTBOX1.VALUE=Range("A1") Like for each control in this userform and then put it into the worksheet and vice versa, show the worksheet data in the userform.
Show!
✌