VBA UI UX-1: Build Professional UI with UserForm. Lots of design tips. Project download free.

This series will cover 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: pamaitech.com/...
👍 Support: paypal.me/pama...
✉️ Contact: [e-mail]
📌What to watch next:
Playlist: www.youtube.co...
Videos: www.youtube.co...
#VbaA2z

[@1908bookworm]

I have been looking for vba ui design tutorials for a while. Finally found your amazing series. Videos are really great! I would love it you could share the source code, I have already sent you a request through your google form.

[@VBAA2Z]

Project download is automated. Please be sure to check spam folder if you do not receive in 5-10 mins.

[@1908bookworm]

@@VBAA2Z Thanks a lot for pointing it out. I was in my spam. Cheers!!!

[@VBAA2Z]

no probs.

[@giovanyrodriguez5100]

Hey, thanks for the great video! I haven't received the email either, I use the 022 ID project and nothing. I checked my spam folder and use two differents email accounts. Can I download it from somewhere else?

[@VBAA2Z]

Please email me or try submitting it one more time. thanks This process is automated

[@gabrielmaria3836]

Really considered Excel VBA UI boring. Something to add life to my projects. Thanks a ton.

[@VBAA2Z]

You're welcome!

[@hoseal8048]

I never knew nor have seen anyone design UserForm like this. This kinda open my eyes :) awesome, thanks

[@VBAA2Z]

Great to hear!

[@jmstampe]

Great stuff...I’ve been doing VBA for over 15 yrs and have always sucked at UI design. This is a great tutorial.

[@elmorslijaouad9105]

Hello, i want to start learning VBA and i am wondering how to find basics things ! can you help please ?

[@franciscoveras7405]

Great video!!! This is something that blows my mind, please don’t stop

[@atstanley711]

I have been looking for someone teaching dashboard design in this design style for some time. Just started watch the videos. So far so good

[@VBAA2Z]

Awesome, thank you!

[@melivo853]

This is brilliant. I have never seen a UserForm designs like this. Thanks for sharing this amazing video

[@VBAA2Z]

Thank you! Cheers!

[@khaledrabea5050]

Although I didn't finish your great video yet when writing this comment, but I must tell you are doing great support. Thank you very much for share and for your great efforts. Keep sharing these useful tutorials.

[@VBAA2Z]

I appreciate that!

[@adietcake]

It is incredible how much you can do with userforms in Excel! I was thinking about creating an UI for a dashboard application directly on the worksheet using vba but now I think using userforms and hiding the worksheet might be a better option. Thank you for your video!

[@VBAA2Z]

glad to hear, thanks for witching.

[@user-uo1td9bt4y]

Wow, I just wanted to take a moment to express my admiration for the incredible work you do on your KZbin channel. Your guides are an absolute lifesaver! The way you break down complex topics into easily understandable segments is truly commendable. You just earned a new subscriber!

[@user-uo1td9bt4y]

Btw I have requested for the source code but I have not received it. I've checked the spam folder but it's not there.

[@VBAA2Z]

You're very welcome!

[@VBAA2Z]

please check again, if you still haven't please email [e-mail]

[@maryfelcagata7612]

This tutorial will help me a lot. I've been working for a library management system using a vba excel for our information system course.

[@VBAA2Z]

Great to hear!

[@oussamakajjoune8549]

Dear Pamai, Thank you very much for your insightful tutorials! They are very helpful for all of us. keep going ;)

[@VBAA2Z]

Glad you like them!

[@VBAA2Z]

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

[@kingsoko5319]

I am so impressed this is possible in VBA. KUDOS!!!!

[@VBAA2Z]

Thank you!

[@michaelbattle9883]

Finally got around to watching the video and managed to get most of it to work, however, had some issues with getting the APIs to remove the Title Bar on the Userform. However, great detailed video. Would like to see the exact coding of the APIs, so will request a download. Fantastic video.

[@VBAA2Z]

Thanks for your support!

[@jamesh-kc7rk]

This is mind blowing. Appreciate you sharing all these amazing tutorials for free.

[@VBAA2Z]

Glad you like them!

[@SidauChe]

Best VBA UI videos I have ever seen. Infact first time I see anyone build such UI. Keep up amazing work 👍

[@VBAA2Z]

Wow, thanks!

[@Huliang-cb7tj]

your channel is gem for VBA enthusiast!!!! what a great demonstration of your creativity and innovation

[@VBAA2Z]

Thank you very much!

[@user-iq9ew8vc4h]

best Excel VBA userform series ever. keep up great work

[@VBAA2Z]

Thanks, will do!

[@SlightTouch-pm6dy]

Kudos to you! Your designs are simply mind-blowing and eye-opening. I can't thank you enough for all the useful and inspiring videos you create. Keep up the fantastic work!

[@VBAA2Z]

Wow, thank you!

[@mihjibiggschaka4010]

I has been doing rudimentary Userform designs for some time until your video showed me the possibilities that exist to produce a professional looking user interface. It has however been difficult to follow the coding process because I have not had access to the source code despite making a request. Thank you very much for the great works that you do.

[@VBAA2Z]

sure, please be sure to check your spam folder too

[@user-ll8up1eu4d]

this channel helps me and my brain to function alot more actively and better thank you so much sir!

[@VBAA2Z]

You're most welcome

[@RealKaydo]

To this point I haven't seen anything like this on the internet. As someone still learning, it would be nice to see the code related to some of the project your are sharing on your channel. But all in all, your work is great.

[@VBAA2Z]

Thanks Kabelo. Download link in video description

[@user-im4vn4yu5i]

This is hands down the most impressive VBA UI I've come across. Your videos have been absolutely fantastic, and I sincerely appreciate the content you share with the VBA community. I eagerly look forward to more of your amazing videos in the future. Thank you!

[@VBAA2Z]

Wow, thank you!

[@timbriers5811]

The video I have been looking for!!!! Thanks for your efforts from Belgium

[@VBAA2Z]

Glad it was helpful!

[@timbriers5811]

@@VBAA2Z I'm just struggling with the following compile error when trying to run the code: The code in this project must be updqted for use on 64 bit systems... Any chance you could tell how to resolve this?

[@VBAA2Z]

this should help vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html

[@VBAA2Z]

@@timbriers5811 this should help vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html

[@user-ll8up1eu4d]

one of the best tutorials on VBA

[@VBAA2Z]

thanks!

[@analistax]

WWOOOWWWW!! These tips are fantastic!!!! Thank for sharing it.

[@VBAA2Z]

You are so welcome!

[@7aidoori]

your narrating style are amazing. good job

[@VBAA2Z]

Thanks a ton!

[@jerseyjuliolorenzopujay6111]

El mejor diseñador de UserForm que vi en mucho tiempo, espectacular!

[@VBAA2Z]

Thank you!

[@abdoallahmanoochehrirad3820]

That was great my dear friend.

[@VBAA2Z]

Thank you! Cheers!

[@DidamNb]

Thank you so much for detailed walk-through. Best Userform tutorial ever!

[@VBAA2Z]

Wow, thanks!

[@VBAA2Z]

You're very welcome!

[@chekha-dr1tl]

This video was explained very well good job, keep up the food work! :)

[@VBAA2Z]

Thanks, will do!

[@debbiefairbanks916]

That's awesome. It looks stunning. You'd never know it was Excel!

[@VBAA2Z]

Thanks. Please do not forget to subscribe, thanks for your support.

[@debbiefairbanks916]

@@VBAA2Z Hi Lung. I've Subscribe'd, Like'd and Comment'd but couldn't access the download. It said "You need access". Is there another way to get the download link?

[@VBAA2Z]

​@@debbiefairbanks916 please check again now.

[@scotolivera8207]

Ow wow , nice interface. Great works sir of course i will subscribe and hit the like button 1000%

[@VBAA2Z]

Thanks!

[@dinawangjkiu9712]

Thanks for great tutorial to stunning UI and introduction to many useful tips and resources.

[@VBAA2Z]

Glad it was helpful!

[@sonuwarsi738]

Excellent turtorial .. You made it look like a web developed UI design.

[@VBAA2Z]

Wow, thanks!

[@ekilunewmai7033]

You amaze me with your dope UI. Thank you so much

[@VBAA2Z]

Happy to hear that!

[@daddamustafa7867]

Good Step by step VBA UI design explanation, Thank you it's really helpful

[@VBAA2Z]

Glad it was helpful!

[@ApirlK]

Pamai, your creativity is simply amazing! Well done!

[@VBAA2Z]

Thank you so much!

[@explorevba2433]

Stunning UI design for Excel UserForm. It is an eye opener video. Thanks

[@VBAA2Z]

Glad you think so!

[@wikamdiopekiang4972]

Best Userform series ever. thanks for ideas and free tuts

[@VBAA2Z]

You're very welcome!

[@dampisong1369]

This is very intuitive. Great job!

[@VBAA2Z]

Glad it was helpful!

[@lamdinliuchewang3610]

best userform design ever. keep up good work

[@VBAA2Z]

Thank you! Cheers!

[@user-er9cg3hg3y]

Your channel is exactly what I was looking for to learn! Thank you

[@VBAA2Z]

Awesome, thank you!

[@skunpy2]

Great tutorial. Following the series.

[@VBAA2Z]

Much appreciated!

[@winingchewang2712]

Stunning UI and very innovative. Thanks for your videos~

[@VBAA2Z]

Glad you like them!

[@venugopal-pn9zt]

This video explained in detail the method of creating user interface with username and password. It was found very useful and it is really amazing .Great effort in explaining the real life projects like this. I have learnt a lot of things, even though I am a beginner in this field. Thank you very much sir.

[@VBAA2Z]

You're welcome! thanks for watching.

[@markcave]

This looks great, It makes perfect sense how to create graphics when you see this, which I could see the code that makes it all work

[@VBAA2Z]

Thanks - please find the link in video description

[@joaquinalzogaray1790]

Hola! Muy buen aporte. La verdad que Excel es una herramienta que no tiene techo y tutoriales como este nos hacen conocer cada vez más la infinidad de usos que le podemos dar. Saludos!

[@VBAA2Z]

Muchas gracias apreciado!

[@antonioneisantos9242]

Congratulations on the excellent material. I want to learn how to make these beautiful and intuitive forms

[@VBAA2Z]

Thank you! Cheers!

[@Arvind_Soni]

Really my search for VBA video has ended up now. U r a brilliant.

[@VBAA2Z]

Thanks 👍

[@Nel-vy7nj]

This is great series. Thanks for sharing your ideas

[@VBAA2Z]

You are so welcome!

[@wilamdinchawang3484]

So glad i came across this. Following the series. Big thumbs up! and subscribed.

[@VBAA2Z]

Glad to hear!

[@setiaone-notionways]

I'm newbie and love to watch this vid.

[@VBAA2Z]

thanks!

[@Chewangz]

Thank you so much for sharing your knowledge and expertise freely. By far BEST VBA CHANNEL !!!!!!!!

[@VBAA2Z]

Wow, thanks! So nice of you

[@Chewangz]

@@VBAA2Z of course!

[@AnalyticsInDetails]

Amazing work of VBA and beautifully explained how to create.

[@VBAA2Z]

Glad you think so!

[@marku88z]

Great tutorials bro. I save most of your videos to watch later. Theres a lot to learn from you.thank you so much

[@VBAA2Z]

Awesome, thank you!

[@alexleopakpahan884]

Thank you so much.. Hopefully i can learn something from all of your videos to make my project better

[@VBAA2Z]

You can do it!

[@sergionambol313]

Dude, you took it to whole new level :) Super thanks from me!

[@VBAA2Z]

Glad you liked it!

[@thiagovilha7570]

Thank you! It helped a lot! Regards from Brazil!

[@VBAA2Z]

Glad to hear that! you're most welcome.

[@hagridpeter4454]

Man seriously your channel is so helpful!

[@VBAA2Z]

Thanks!!!

[@mehtag7810]

You've a unique thingy going on. Keep going, will definitely support

[@VBAA2Z]

Welcome aboard!

[@mif1965]

Great video, good instruction and great hands on example. Probably best tutorial on VBA IDE I have seen

[@VBAA2Z]

Wow, thanks!

[@colegiojosephdaniels5946]

Awesome tutorial, love the speed. You cover a lot fast and we can go back, great work.

[@VBAA2Z]

Glad it helped! thanks for watching.

[@felipethum5832]

Outstanding job... a unique work. I will see all videos in your channel!

[@VBAA2Z]

Thank you! Cheers!

[@ElectromecanicaIndustrial]

starting this playlist on 03.05.2023 at 20:23pm. coming back when I finish it all

[@VBAA2Z]

All the best!

[@sunil5149]

Thank you for sharing these excellent tutorials. please keep up the good work.

[@VBAA2Z]

My pleasure

[@holieh5301]

Rewatching this. This is simply awesome . You’re the man

[@VBAA2Z]

Thanks Holie!

[@Chafai7z11]

this is simply amazing man. Kudos

[@VBAA2Z]

thanks Ashu!

[@NManub]

You are very creative sir. Great work!

[@VBAA2Z]

thanks

[@ARUSBAWAH95]

one the best for all vba tutorial, a have already sent request throught your google form

[@VBAA2Z]

processed please be sure to check spam folder too

[@sanimahama718]

Good job, looking for something like this a long time

[@VBAA2Z]

Thanks - Glad you like it!

[@jatinbhasin9859]

This is masterpiece, great learning, this is surely gonna help me with my projects. Keep posting such great stuff.

[@VBAA2Z]

Thanks, will do!

[@katusiimeberen6299]

This is awesome. Can't believe its excel

[@VBAA2Z]

Thank you!

[@amjanlalani9839]

Thanks! Hope to study this further!

[@VBAA2Z]

All the best!

[@Nphum]

wow this is amazing bro thanks for sharing your creativity

[@VBAA2Z]

Thank you so much 😀

[@kayahafriyat5507]

have been looking for vba ui design tutorials for a while. Finally found your amazing series. Videos are really great! I would love it you could share the source code, I have already sent you a request through your google form.

[@VBAA2Z]

Be sure to check the spam folder too. The download is automated so if your email id is correct you'll receive it.

[@jenniferalexander8]

@@VBAA2Z The forms didn't make sense to me - I wanted to purchase some stuff but can't even download freestuff

[@VBAA2Z]

@@jenniferalexander8 if you're submitted please check spam folder as well

[@kenw2086]

Fantastic video! I just found your channel and I am looking forward to upgrading my VBA skills, especially regarding userforms.

[@VBAA2Z]

Awesome, thank you! Welcome aboard!

[@Sim35may]

This is a miracle!!! Thank you so much for your Great Job.

[@VBAA2Z]

Glad it helped!

[@brokenMikrophone]

Awesome. I spend 5 years believing only grey mess is possile with userfoms. thank you

[@VBAA2Z]

Thanks, glad you found it useful

[@brokenMikrophone]

@@VBAA2Z I also checked out your code from your blogspot, shame it only works for 32bit versions. But it is very good excercise to rewrite it for 64 or even both. nonetheless 10/10 video

[@VBAA2Z]

@@brokenMikrophone Simply add 'PtrSafe' before Function to make the API compatible for 64-bit. vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html All episodes works for 64-bit too.

[@brokenMikrophone]

@@VBAA2Z very true

[@robbertbradfield636]

You make it look so easy and it is. Thank you.......

[@VBAA2Z]

You’re welcome 😊

[@chickenpathia]

Excellent UI isage and clear description

[@VBAA2Z]

Glad it was helpful!

[@dannylasso7918]

Thank you so..... much! I have watched the entire series of VBA UI UX and 'm super impressed, great design ideas and implementations. Keep up great work. One quick question / request - please demo how to create a border-less Form (non-full sreen) with custom menu where user can still move the form.

[@VBAA2Z]

Great suggestion! I show more design ideas. Please do not forget to support channel.

[@dannylasso7918]

@@VBAA2Z ok thanks will be waiting.

[@penny2921]

Amazing UI. great work! many many thanks for sharing the project

[@VBAA2Z]

Glad you like it!

[@anikabradac2852]

Great Video! Exactly what i was looking for! Thank you

[@VBAA2Z]

Great to hear!

[@KevinAanensen]

Yeah this stuff is mind blowing and very very helpful. Shame I haven't got a link yet to use this amazing stuff.

[@VBAA2Z]

Glad it was helpful! please be sure to check spam folder too. All request have been processed

[@iiiarmchair]

Great videos, very helpful. Thanks!

[@VBAA2Z]

You're very welcome!

[@mnewmai9413]

Wow this is mind blowing, thank you so much for sharing the project! really appreciate your help.

[@VBAA2Z]

Glad it was helpful!

[@shofyantotivianto3077]

Wow this project very good, Thank for sharing...!!

[@VBAA2Z]

Thank you! Cheers!

[@kinga334]

I agree with follow viewers... simply wow. Keep it up sir. Thanks a lot!

[@VBAA2Z]

So nice of you

[@tiffanyjanish332]

great tutorial! just what I have been looking for thank you!

[@VBAA2Z]

Glad it was helpful!

[@FukSN]

Just came across this video and found it really useful. I understand this video is more about the UI but I would love a video (if possible), on the UserForm code. Specifically looking for an explanation on the Functions you have created, what they do and why you used them. But thank you for this video, I look forward to checking some of your other videos out.

[@VBAA2Z]

Thanks Mils. Please let me know if you have any specific questions.

[@davidchayka4241]

Thanks for helping with the learning curve.

[@VBAA2Z]

Glad it was helpful!

[@rafibimakautsar2151]

Thank you for the tutorial. Its really clear and helpfull for me

[@VBAA2Z]

You are welcome!

[@robertgothenc9790]

excellent content. keep up the good work.

[@VBAA2Z]

Much appreciated!

[@thomasweber7690]

simply mischief, never seen a unprofessionial Tut like this *grml*

[@VBAA2Z]

Thank you Thomas!

[@jennyoles293]

thank you sir. I love your contents, keep it up!

[@VBAA2Z]

Thank you too!

[@opul77]

un bellissimo tutorial grazie mille per il bel lavoro svolto

[@VBAA2Z]

Grazie!

[@linnick9235]

Very useful tutorial. Following the series here.

[@45Dinu]

excellent example. Keep doing. Thanks.

[@VBAA2Z]

You are welcome!