VBA UI UX-18: Latest Excel UserForm Designs using VBA Windows APIs

[@VBAA2Z]

Do you want to download these Cool 7 UI Samples + Source Code for free?
Simply Like, Subscribe, Comment, and Share it with your friends.
🤝Thanks as always for your support!

[@danielbekele8853]

i have done all you have asked to do but still i don't get the download link to this project

[@Gandaki_News]

how cal download

[@Gandaki_News]

How to download

[@josemirmoraes3890]

Congratulations!! Excellent content. Thank you so much for publishing this series!

[@VBAA2Z]

Glad you like them!

[@pekidonn5139]

@vbaa2z these are amazing. Thank you so much

[@VBAA2Z]

Glad you like them!

[@benjaminf5731]

it is mind blowing how you come up with all this designs. Great work!

[@VBAA2Z]

thanks!

[@aidanmcdonnell9199]

Amazing Videos, I am in awe of your coding ability in Excel. It is the equivalent of putting a man on Mars!

[@VBAA2Z]

:) thanks, glad you enjoy it!

[@kuksten1579]

Thanks for sharing these useful projects and information for free.

[@VBAA2Z]

My pleasure!

[@ekilunewmai7033]

Thanks for Stunning UI design and collection. Keep up great work

[@VBAA2Z]

Glad you like them!

[@wennychez5606]

Thank you sir for sharing. Awesome designs

[@VBAA2Z]

My pleasure

[@brokenMikrophone]

great stuff! every video I watch makes me question my abilities but also inspires me and teaches me that there is more to discover

[@VBAA2Z]

Great to hear!

[@holieh5301]

Mind blowing. Keep going Pamai

[@VBAA2Z]

Thanks a lot 😊

[@patelcontractors8127]

Awesome work! Thanks for sharing.

[@VBAA2Z]

Thank you! Cheers!

[@patelcontractors8127]

@@VBAA2Z
Please help me to receive the download of your great work. Thanks in advance.

[@bubbletj95]

This is awesome. Thank you so much for this series! :)

[@VBAA2Z]

You're very welcome!

[@SaraPerzYT]

Another great addition. Cheers!

[@VBAA2Z]

Thank you! Cheers!

[@arianjico4441]

Thanks for sharing your knowledge and projects for free

[@VBAA2Z]

So nice of you

[@NancyCa198-a]

This is awesome sir. Thank you so much for uploading all these amazing Modern UI for FREE.
Liked, shared and commented least I can do for you sir. Keep up great work!

[@VBAA2Z]

Thanks my friend. Appreciate your kind words. Project on your way :)

[@venugopal-pn9zt]

Thank you very much for this wonderful video regarding Windows API. Learnt a lot of things from this.

[@VBAA2Z]

You are most welcome

[@nikhilnarkhede34a]

One of the very best channels on TH-cam. Respect 🙌🙌🙌🙌

[@VBAA2Z]

Appreciate that.

[@rafaelmammadov7435]

Thank you very much for efforts. Warm greetings from Azerbaijan.

[@VBAA2Z]

You are welcome!
thanks for watching.

[@GoncaloFly]

great collection, thanks for sharing

[@VBAA2Z]

Thanks for watching!

[@penny2921]

Thank you so much for sharing all these practical useful samples.

[@VBAA2Z]

You are so welcome!

[@sunnylokesh3500]

Awesome ideas and designs, thanks sir

[@VBAA2Z]

Many many thanks

[@WeningWang]

Very informative and innovative, thank you

[@VBAA2Z]

Glad it was helpful!

[@mmbcampus]

Dont know how many times i watched this.... today I started my morning by watching this video from my bed :D

[@VBAA2Z]

thanks for watching.

[@alessandrorivadossi2283]

Thank you mate! Great job!

[@VBAA2Z]

Thank you too!

[@alessandrorivadossi2283]

Sorry how can I download the API? I tried to follow the instructions but I'have never received the email

[@rafibimakautsar2151]

Thanks Lung Pamai, this is really helpfull

[@VBAA2Z]

Glad to hear that!

[@kingsoko5319]

Very useful video, thank you so much

[@VBAA2Z]

You are welcome

[@ahmadfadhil5593]

This is awesome.Thank you very much!!

[@VBAA2Z]

You're very welcome!

[@Lorenzo_iMa]

This is great. thank you so much for sharing.

[@VBAA2Z]

Glad it was helpful!

[@luckylep09]

Thank you very much!!! You have done a great job of presenting clear and understandable information that is up-to-date

[@VBAA2Z]

Glad it was helpful! thanks for watching and for your support!

[@abafirasse6824]

thank you so much great teaching

[@VBAA2Z]

You are welcome!

[@mauriciotato1053]

Amigo excelente tutoriales, con diseños que no se me habían ocurrido hasta quite te vi hacerlos, sigue así, gracias por contribuir al conocimiento público!!!

[@VBAA2Z]

Gracias por sus amables palabras y su apoyo. 🙏
Thanks for your kind words and support.

[@Chawangs]

another wonderful episode thanks!

[@VBAA2Z]

Glad you enjoyed it!

[@OfficewithAtiq]

Awesome, mind-blowing sir

[@VBAA2Z]

Thanks a lot

[@GIG-ATT-ATT-GIG]

Brilliant! Thanks Pamai

[@VBAA2Z]

Thanks Roland

[@mariosantos871]

Fantastic! Thank you

[@VBAA2Z]

Glad you liked it!

[@sihlemhlanga6858]

This is what I have been looking for. Thanks

[@VBAA2Z]

you're welcome

[@VBAA2Z]

try re-submitting again as the process is automated or email(in video desc.) the team

[@sihlemhlanga6858]

@@VBAA2Z I have received the file. Wow! the file did not disappoint. Yo really know your thing.
Thanks a lot, a cup of coffee is on its way.

[@VBAA2Z]

Glad to hear that. much appreciated.

[@sajheoz3591]

Thank you sir for sharing.

[@VBAA2Z]

My pleasure

[@kevinfairdosi1638]

This is really great, thank you for sharing!

[@VBAA2Z]

Glad it was helpful!

[@AlengChawang]

Thanks for another awesome tutorial

[@VBAA2Z]

My pleasure!

[@GiselleBrat]

great content! keep it up.

[@VBAA2Z]

Appreciate it!

[@adriendftb157]

Thank you very much for this sharing

[@VBAA2Z]

My pleasure

[@ayoubbakkari7709]

Thanks you're in the next level 👌

[@VBAA2Z]

I appreciate that!

[@JerdelSAYA]

you're just wahou thank you so much sir!!

[@VBAA2Z]

So nice of you

[@s.mujtabaalnajjar779]

Excellent job

[@VBAA2Z]

Thank you! Cheers!

[@Prince_Chaurasia]

Very nice n helpful tutorial

[@VBAA2Z]

Thank you! Cheers!

[@ronhatt]

This is great. Asked for download.

[@VBAA2Z]

Thanks!

[@fksoftware]

Very useful Sir.

[@VBAA2Z]

Glad to hear that. Thanks for watching

[@ganeshs1360]

This is amazing! I just wanted to know is there a way to resize the controls in the form when the form is getting resized? And how do we set a form size and the controls based on the screen resolution?

[@VBAA2Z]

yes you can.

[@ganeshs1360]

@@VBAA2Z is there a tutorial on your channel on this? It will be really helpful

[@dandeman1148]

Lots to learn !

[@VBAA2Z]

all the best!

[@dandeman1148]

Thanks. I went to the website to download but haven't received anything in my email

[@VBAA2Z]

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

[@tungsonnguyen7988]

wow, look so cool!

[@VBAA2Z]

Thank you! Cheers!

[@tungsonnguyen7988]

@@VBAA2Z
How to get the workbook? I’ve done all your requirements.

[@mohammedkebir6423]

this is awesome. Thank you so much

[@VBAA2Z]

You're very welcome!

[@noelsongfce2825]

thank you for this best video

[@VBAA2Z]

Most welcome

[@abdelyazidhmansan4337]

Thanks, nice work!

[@VBAA2Z]

Glad you liked it! Thanks for watching.

[@jmiller007]

Great content, one area i've always lack experience in is working with windows APIs.

[@VBAA2Z]

Glad it was helpful! thanks for watching and for your support.

[@kingsoko5319]

Amazing 😍

[@VBAA2Z]

Thanks 🤗

[@barcelonaforever2138]

Hola, todo está espectacular, no tenía idea de que se podía hacer esas cosas en los formularios, te felicito, me gustaría poder descargarlo, le envié la solicitud hace una semana pero no llegó ni al spam o ya no está gratuitamente? Gracias.

[@VBAA2Z]

Thanks

[@stephanebonconor9514]

Merci beaucoup pour le partage de code!!

[@VBAA2Z]

Thanks for your support!

[@glensimon3011]

Another great video!

[@VBAA2Z]

Glad you enjoyed it!

[@keunr.5628]

That's amazing!! Thx ^^

[@VBAA2Z]

Most welcome, thanks for watching

[@xanderbuynsel5986]

This is very great. Thanks for sharing your kmowledge. Maybe you can do also how to make pagination using access db in vba excel. 😊😊😊

[@VBAA2Z]

You're most welcome.
Thanks for the idea!

[@valachibrothers1295]

This is impressive

[@VBAA2Z]

thanks

[@aj34321]

Awesome video...

[@VBAA2Z]

Thanks for the visit

[@pavlinagajdulova8517]

Awesome!

[@VBAA2Z]

Thank you! Cheers!

[@danielbekele8853]

I LIKE IT SIR IT AMAZING DESIGN

[@VBAA2Z]

Thank you! Cheers!

[@Danielhss]

great video

[@VBAA2Z]

You are most welcome. thanks for watching.

[@jimovia]

great tutorial all the way

[@VBAA2Z]

Glad you liked it. thanks

[@azel2239]

Great...thanks a lot!

[@VBAA2Z]

You are welcome!

[@kevinpatel3326]

🙏 awesome

[@VBAA2Z]

Thanks!

[@abcdef-w7z4e]

Woo fascinante 😍

[@VBAA2Z]

Thanks!

[@scottymars3289]

Thank you so much!

[@VBAA2Z]

You're welcome!

[@mdmohashinbhyian3529]

Wow....great

[@VBAA2Z]

Thank you! Cheers!

[@SuperRoisoleil]

This is great. thanks

[@VBAA2Z]

You're welcome!

[@KouroshBashiri]

nice work bro!

[@VBAA2Z]

Thank you! Cheers!

[@husammansour740]

Cool video

[@VBAA2Z]

thanks

[@zitomoreno9408]

Amazing job, did you do an rich textbox?

[@VBAA2Z]

Thanks. Nothing special, I just used UserForm controls + APIs

[@ouiss001]

Cool thanks

[@VBAA2Z]

You're welcome!

[@tithdarith]

Amazing Videos

[@VBAA2Z]

You are so kind. thanks

[@xiscrianca]

Parabéns pelo trabalho.

[@VBAA2Z]

thanks!

[@alexblue2277]

Good

[@VBAA2Z]

Thanks

[@blank-xi9uw]

Nice!

[@VBAA2Z]

Thank you! Cheers!

[@zeshankhan2455]

Sir. Agar last row ko aik sa zayada bar type kr na ho to to kasa ho ga?. Same sheet Mai. Sarif sariel number change ho. Baki data same hi rha. Plz explain me. Userform mai kasa codeing ho ge Jasa aik itam ki quanutty 5 pice ha. Ab sarial number to different ho per Baki data same copy ho.

[@VBAA2Z]

Thank you!

[@zeshankhan2455]

I m w8g your reply

[@markstephens3808]

Hi there, been playing around with your list box class shown at 5.36 in the above video, and am a little puzzled wonder if you can help. As well as having the special effect changed (etched) whenever a control is moused over, I was looking to also change the colour, so I added the code for the back colour to change accordingly. It worked great except the colour stayed after mouse over and I was thinking the reset_eff_img procedure could take care of it as it does with the special effect property, but intellisense doesn't give the option to access the back colour property (actually it doesn't list the special effect property either which makes me think maybe I can access it anyway, can you help with that?

[@markstephens3808]

Hi, please ignore my last post, I figured it out, as I was right, even though intellisense did not list the property, I could access it and it works fine:) Fantastic videos, really pouts me in control of my UI which is exactly what I have been looking for, thanks!

[@VBAA2Z]

Glad to hear. thanks for watching and for your support!

[@탄이탄]

nice

[@VBAA2Z]

Thanks

[@itamaroliveirasampaio4628]

Parabéns! sensacional

[@VBAA2Z]

Obrigado!

[@lehuynhuc6492]

OMG. VBA Excel can do it? Unblievable!!!!!!

[@VBAA2Z]

thanks for watching and for your support.

[@dindon011]

Fantástico

[@VBAA2Z]

Thank you Rodrigo

[@wangniperinmai]

thanks

[@VBAA2Z]

You're welcome!

[@senthilkumarsatyavruthan3993]

Is there a possibility to add UI UX design to worksheets and not only in Userforms

[@VBAA2Z]

yes of course. Same approach. Use shapes

[@Bryan-tw7oj]

Thank you for sharing , i’d like to see if i can get a copy please :)

[@VBAA2Z]

Yes, please submit request using link in video description.

[@TheLaopi]

Very great vidéo, i am interested received thé projekt

[@VBAA2Z]

Thanks and sure, please be sure to check spam folder too

[@lyoko1237]

great works

[@VBAA2Z]

Thank you! Cheers!

[@richardardani2516]

nice job. can i download it?

[@АлександрСелюн-р9ъ]

Thank you

[@VBAA2Z]

You're welcome

[@OfficewithAtiq]

Kindly share the source code and project material to use this awesome form

[@VBAA2Z]

Sure - check back in couple of hours, it'll be updated in description.

[@VBAA2Z]

Project added

[@aj34321]

But unable to download the source codes.. How do i download them?

[@VBAA2Z]

All request have been processed, please be sure to check SPAM too-thanks

[@ruimarques1177]

well done :)

[@VBAA2Z]

thanks!

[@photogpphotogp7468]

Hi Pamai, in the example - SAMPLE6_Disclose - I'm having the following error - "Run-time error '91': Object variable or With block variable not set.
The only thing I did was to copy the instruction:
Private Sub UserForm_Initialize ()
On Error Resume Next
Call DisableCLoseButton (SAMPLE6_Disclose)
End Sub
for the userform.
Some help?

[@VBAA2Z]

in SAMPLE6_Disclose userform there is an image 'Image3' which hold the form icon. Please make sure that exist.

[@photogpphotogp7468]

@@VBAA2Z "Image3" exists. The error occurs when I close the Userform.

[@VBAA2Z]

Not sure why that'd be, it simply executes Unload method.
Private Sub Label1_Click()
Unload Me
End Sub

[@photogpphotogp7468]

@@VBAA2Z i ill make a small video and send you by email

[@photogpphotogp7468]

@@VBAA2Z Sended. Thanks

[@fongangyemdjivaldo4053]

Hi vba A2Z, I have submitted my demand several times but i still haven't received it yet.
Thank you

[@raahulg6203]

Greate....

[@VBAA2Z]

thankss

[@artovartiainen1377]

Wau!

[@VBAA2Z]

thanks!