VBA UI UX-4: Create Custom Form with dynamic menu and icon. Real-life App -E1

[@VBAA2Z]

Hello, just uploaded project files/materials. Please go ahead and download them. Again please feel free to comment if you have any questions. Your support is much appreciated! regards.

[@OfficewithAtiq]

How to download? When i click on download so, a request form is being sent

[@b2pmst]

Hi where do i download the project files and materials

[@VBAA2Z]

You should see the response in the email.

[@OfficewithAtiq]

@@VBAA2Z no email received sir, still waiting

[@modamerx549]

Yes no email received sir i tried twice ☺️

[@gerardoparente3295]

I discovered this channel casually and I have to say "fantastic"

[@VBAA2Z]

thank you!

[@scotolivera8207]

Every time I think that excel vba is done , you upload a new video that change my mind. Great work brother , great content

[@bnancy3699]

Agree 100% :)

[@JoshKingiu]

Loving this series, thank you

[@VBAA2Z]

Glad you enjoy it!

[@ajikobisulaimon2947]

This is a very nice one Bro.Keep this as the sky is your limit.Helping Humanity

[@VBAA2Z]

Thank you, I will

[@takorronald1021]

These menu options are amazing. I wish i found these videos earlier

[@VBAA2Z]

Glad it was helpful!

[@ralphlewis4350]

another fantastic teaching video, Keep up the great work

[@VBAA2Z]

Many thanks!

[@CelsonFC]

Awesome Man!

[@VBAA2Z]

Thanks for the visit

[@andyest8580]

Excellent tutorials. I have never seen VBA UI design like this

[@alexday1315]

These videos are great man keep it up!

[@holieh5301]

This is excellent! Following and looking forward to building complete app. Thanks a lot!

[@dinawangjkiu9712]

I like your ideas..very innovative with whatever is available.

[@VBAA2Z]

Thank you! Cheers!

[@shellynomis7368]

Dude, you have amazing contents. Keep up this excel(lent) work :)

[@VBAA2Z]

Thanks, will do!

[@frankied2782]

Great video, thanks!

[@VBAA2Z]

You're welcome!

[@pedche5790]

Very informative video. thank you

[@VBAA2Z]

Glad it was helpful!

[@Unnala]

This is another amazing video. thank you .

[@VBAA2Z]

Glad you enjoyed it!

[@adriendftb157]

Great work !!

[@VBAA2Z]

Thanks

[@NagaVlogger]

Fantastic! thank you

[@VBAA2Z]

Thank you too!

[@Akulion1]

Wow this is great work, thanks for sharing it :)

[@VBAA2Z]

You're welcome. Glad you found it useful..

[@mnewmai9413]

Learned a lot from you sir. Thank you so much

[@VBAA2Z]

You're most welcome. thanks for watching.

[@scottymars3289]

wow looks awesome. thanks for sharing.

[@VBAA2Z]

Thanks for watching

[@lehuynhuc6492]

Good job men!

[@VBAA2Z]

Thanks!

[@bnancy3699]

this is excellent. thank you so much!

[@rodmaxwell8182]

Great tutorial, good content - thanks a lot!

[@VBAA2Z]

You're very welcome!

[@karthikeyankayambu9567]

Awesome work.

[@VBAA2Z]

Thank you so much 😀

[@MK-vp2sp]

These videos are great. Liked and subscribed as you are my new go to person. I'm fairly new to VBA and have designed my own user form but would really love to adapt and add this feature to my doc. The side menu looks so good. However when i go to the download page i dont see VBA UI UX-4. I can see 1, 9, 19, 21, 23

[@VBAA2Z]

Thanks! please refer to free section for free projects.

[@Nel-vy7nj]

Great video

[@VBAA2Z]

Glad you enjoyed it

[@shahzebchoudry6175]

Sir plz guide which playlist first we fellow to watch ur videos complete engineers in excel VBA

[@enowdalintin8986]

Great 🥰

[@VBAA2Z]

Thank you! Cheers!

[@al-aminmollah7650]

Really awesome!

[@VBAA2Z]

Thank you! Cheers!

[@pamchamzell4489]

Very useful thanks for the video ☺️

[@malmins22]

Looking forward to downloading this

[@VBAA2Z]

sure, thanks for watching

[@malmins22]

Hello, when I add the background image it looks good. But then when I add the multipage it goes over the image...how can I do it to look like yours?

[@VBAA2Z]

Multipage does not have transparent property. Following episodes cover work around.

[@malmins22]

@@VBAA2Z thank you will check them out. I rewatched the episode and had missed just putting the picture with the mountain was trying to put the entire image with menu lol 😆

[@VBAA2Z]

@@malmins22 glad to hear you got it working.

[@bhootsxd4089]

I keep having runtime errors when I hover my mouse over the labels. Please help kind sir

[@VBAA2Z]

What is the error You're facing?

[@Noune-fp2qr]

Awesome thanks

[@VBAA2Z]

No problem!

[@bhootsxd4089]

How do I use the class and class module on the userform tho? Thanks

[@VBAA2Z]

please check kzbin.info/www/bejne/pKjZYYOmqcqejLc

[@bhootsxd4089]

@@VBAA2Z appreciate it brother, keep up the good work

[@VBAA2Z]

@@bhootsxd4089 thanks

[@Tulasi-q2k]

Great work

[@VBAA2Z]

Thank you! Cheers!

[@Putt-Putt]

How do you import that rectangular shape with the shadows into Userform?

[@VBAA2Z]

please watch this series from beginning. Link kzbin.info/www/bejne/pmqWe4WgiauKo8U

[@willianmachadofishing1355]

Sensacional

[@VBAA2Z]

Thanks!

[@dstorm2007]

Hi. Was wondering if there is a way to use images/logos with transparent background as images in userform? I always get white background despite it being transparent

[@VBAA2Z]

As far as I know PNG image type is not an option unless you are using API.

[@rashane1000]

Hi, can't see the project files/materials for this. By the way, applause for making this kind of content. Really helps alot. Cheers!

[@VBAA2Z]

Thanks for visit. Please check vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html

[@tomcarr9692]

Great series, love the content. But isn't that purple, not blue!?

[@VBAA2Z]

'm color blind :)

[@asn6543]

Hi Sir, Lots of thanks for these series VBA UI UX. Is it possible to dowload the project somewhere? Best

[@VBAA2Z]

Please check video description for project. All project and code are free for download and use.

[@GIG-ATT-ATT-GIG]

Nice tutorials

[@VBAA2Z]

Glad you like them!

[@Jusils]

Thank you so much

[@VBAA2Z]

You're most welcome

[@FloaTOR]

These modern looking UIs are beautiful. I'm having difficulty downloading project file.

[@VBAA2Z]

Thanks. Please submit from here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html

[@photogpphotogp7468]

Hi Pamai, another great video. How is it possible to make this menu with the icons embedded in the Userform? It is much easier if we want to distribute the file to other colleagues.

[@VBAA2Z]

Yes you can however the file will get heavy. So you can either imbedded using picture property or dynamically load using LoadPicture method.

[@sammebakshi]

Hello Sir how you made a left side menu will you guide me

[@VBAA2Z]

You're in right place. 'm not clear with your question. Please check this link for complete series. kzbin.info/aero/PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p

[@susilsxzen-ff1zn]

Thank you

[@VBAA2Z]

You're welcome

[@juansebastiancortazar3322]

how do you keep order of many UserForms stacked on top of each other? I'm building an interface with many "nested" pop-up menus

[@VBAA2Z]

Watch the entire series. It'll guide you to build professional UI with best practices.

[@oscarcuellar3891]

This work is very impressive! I tried to replicate it on my own and I had issues getting other bottoms (beside active one) to go back to their default mode. I would think that it would go in reset_all sub or click event but neither worked for me :(

[@OfficewithAtiq]

Need access to download codes

[@melodytait2596]

Are you still sending the free resources for download? I had submitted a request last week and today but haven't heard anything back. Thank you! I hope you keep uploading!

[@VBAA2Z]

Thanks Melody. To promote code yourself and help sustain the channel, some tutorial source code downloads are discontinued. Please let me know if you're stuck / need help, I will respond as soon as possible. for free projects refer to ' Free Projects / Source Code section.

[@Sicilia-rn1hc]

thanks a lot

[@VBAA2Z]

You are most welcome

[@sammebakshi]

How to make the left menu

[@VBAA2Z]

You're in right place. 'm not clear with your question. Please check this link for complete series. kzbin.info/aero/PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p

[@Iamjatinbhasin]

Bro, this is a masterpiece but where are the codes to make this file working?

[@VBAA2Z]

To promote code yourself, projects/codes downloads are not available. Please let me know if you're stuck / need help. You can download similar project from here kzbin.info/www/bejne/eZrEXniFa7CjfKM

[@gabrielbolanos3007]

i want to download the files

[@ermacheton]

Why you call it VBA if you are working on Visual Basic? I'm confused..

[@VBAA2Z]

Hi Rolando, this UI/UX series is done using VBA, for VB.NET series follow VSTO Series. VBA is a subset of Visual Basic specifically designed for office applications so that you can directly code within applications like Excel, Word, Access etc. giving developers huge exposure to office application libraries for automation.

[@ermacheton]

@@VBAA2Z thank you so much for your reply. I'm very familiar with VBA, I develop in ACCESS VBA, what threw me off is that I was expecting to see ACCESS environment and not Visual Basic, I guess my question is How can I use this form for Microsoft access?

[@traptown481]

VBA A2Z

[@Mira-kp5di]

Great job 👏

[@VBAA2Z]

Thank you! Cheers!