VBA UI UX-2: Add web-like effects to Excel UserForm Controls

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

[@hwanlee9110]

Nice work. No one would believe that this UI design is running on VBA.

[@VBAA2Z]

thanks!

[@holieh5301]

Adding effects looks fab 👏👏 and this is the first time I’m learning how useful is creating Class Object. This is superb and informative.

[@izotodepuera]

Hands down brother! You have made VBA userform great again. Keep doing the good work.

[@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]

Great to hear!

[@sylvin3406]

Glad I came across vast array of VBA amazing tutorials. Thank you!

[@VBAA2Z]

You're very welcome!

[@brennarogers3088]

the attention to detail is amazing!

[@VBAA2Z]

Thanks!

[@dinawangjkiu9712]

Best usage of class I have seen so far :) thank you for great tutorial!

[@VBAA2Z]

Glad it was helpful!

[@sidaun9327]

Very useful video, i have never seen this kind of userform design like this. Thank you sir

[@Kumaranmoljha]

Very useful channel for VBA , nice video again woo.. nice video,

[@WeningWang]

Amazing work vbaa2z. thanks for sharing your knowledge

[@VBAA2Z]

Thanks for watching!

[@user-rq5ln7fg5e]

Thanks for all tips. Try to redo myself !

[@VBAA2Z]

Perfect!

[@user-oy3zj3zr2w]

Vba A2Z Amazing channel.

[@VBAA2Z]

thank you

[@shaojuanzhang1834]

This responsive forms are so cool. Thanks for sharing

[@VBAA2Z]

Glad you like them!

[@Nel-vy7nj]

Another great video. Thank you so much.

[@VBAA2Z]

Thanks for watching!

[@alexcrown497]

Отличное объяснение необходимости классов! Прости и понятно и, главное, очень полезно!

[@VBAA2Z]

Happy to hear that! thanks for watching.

[@user-ew7ke2xi2k]

brilliant and super creative! thank you

[@VBAA2Z]

Thank you! Cheers!

[@jimohsuleadekunle5395]

excellent, Very useful video, I have never seen this kind of userform designed like this. Thank you.

[@VBAA2Z]

You are welcome!

[@winingchewang2712]

this is best VBA channel. thank you sirji

[@VBAA2Z]

thank you!

[@kizannbung486]

Very useful 👍good job 👍keep going 👍

[@wilamdinchawang3484]

Appreciate knowledge sharing and effort. Great job. Thanks again

[@jaspeeg]

excelent, Very useful video, i have never seen this kind of userform design like this. Thank you.

[@VBAA2Z]

You are welcome!

[@bnancy3699]

I have to agree with follow viewers, this is absolutely fabulous. thank you

[@deisepereira8236]

The best VBA channel! 👏

[@VBAA2Z]

Thanks for your compliment :)

[@Shuiniu-df9ds]

Your videos are incredible. Thank you so much Say

[@VBAA2Z]

You are so welcome!

[@Rahul-sn1wn]

It looks very beautiful. Looking forward to next video. Thanks

[@Mira-kp5di]

Another awesome video

[@VBAA2Z]

Thanks for the visit

[@monsesamme]

It's a wonderfull and amazing job ! I'm like ejected from m'y chair🤩🤩

[@VBAA2Z]

Hi Messame, thank you! 😊

[@buih2]

Amazing! I'm so glad I found this channel.

[@mariosantos871]

Very nice. I love the lesson on CLASSES

[@VBAA2Z]

Thank you! 😃

[@mrkjmnz]

Starting to make my own project and this is a great help.thanks.

[@VBAA2Z]

Glad it was helpful! thanks for watching

[@akhapamai8135]

Very informative. Thanks

[@pamchamzell4489]

Love your videos keep going 🤗🤗🤗

[@LankoDora]

this is awesome. Thank you so much

[@VBAA2Z]

You're very welcome!

[@user-dp5xg7wf2b]

Thanks for another lovely day

[@VBAA2Z]

My pleasure!

[@susilsxzen-ff1zn]

Thank you for very useful video

[@VBAA2Z]

Glad it was helpful!

[@user-rx2ei2uu8q]

Awesome 👍

[@VBAA2Z]

Thank you! Cheers!

[@annanamdau1605]

Nice one☝

[@7aidoori]

great job. keep going :)

[@VBAA2Z]

Thank you! 😃

[@junjor]

Amazing Video, but for me a little bit too fast (but maybe it's because I'm German and don't speak English very well) :) however, maybe it is sometimes better to accept a longer but more detailed video... no matter, guy, excellent work!! Thanks

[@VBAA2Z]

Thanks for the tips!

[@BrainsEatZombies35]

Thanks

[@s.mujtabaalnajjar779]

Very nice!

[@VBAA2Z]

Thank you! Cheers!

[@Wilmerne]

Thanks for sharing your knowledge.

[@VBAA2Z]

My pleasure! thanks for watching

[@simplejuan]

Learning a lot from this great tutorials. Thanks again!

[@VBAA2Z]

Glad you like them!

[@Sicilia-rn1hc]

awesome, thanks!

[@VBAA2Z]

You bet!

[@IrenaSlws]

this is fab! great work

[@VBAA2Z]

Glad you like it!

[@kinwiliu999]

Fab. Keep it up!

[@anatolyhazan9777]

Great ideas.

[@VBAA2Z]

Thank you! 😊

[@lamdinliuchewang3610]

brilliant sir

[@VBAA2Z]

thanks!

[@ningsan1054]

Great 👍

[@VBAA2Z]

Thank you! Cheers!

[@valachibrothers1295]

Very good

[@VBAA2Z]

Thanks

[@narcelioteixeira861]

excellent

[@VBAA2Z]

Thank you! Cheers!

[@user-oy5go4uv6o]

brilliant work!

[@VBAA2Z]

Thank you! Cheers!

[@Nphum]

superb

[@VBAA2Z]

Thank you! Cheers!

[@usamanaeem8737]

Wow. You are brilliant

[@VBAA2Z]

Thank you! Cheers!

[@poponaplo3442]

Amazing, Very Beautifull

[@VBAA2Z]

Thank you! Cheers!

[@mehtag7810]

nice one

[@VBAA2Z]

Thanks for the visit

[@victoriaagbenuakinsulire882]

Nice Video

[@VBAA2Z]

Thanks

[@wardimagetanyashli6764]

good project

[@VBAA2Z]

thanks

[@kenc8411]

You know, I found a lesson I wanted to learn from you, but when I finish that, I don't where to continue!

[@VBAA2Z]

I highly recommend VSTO Series or ADO Series. kzbin.info/aero/PLo0aMPtFIFDqaRyd0KZ0DLXFD3rfhI4SU

[@reynaldonelwin]

Love your videos! I am interested in multi level filter with userform shown on this video 00:20 - 00:25. Have you created a video tutorial for this?

[@VBAA2Z]

Please check out this video kzbin.info/www/bejne/h3-8oZyJibSLbdk This can be easily implemented in any other projects

[@stephaneguemo9520]

Like it!

[@VBAA2Z]

Thank you! Cheers!

[@kingqiabonmai1890]

thank you

[@VBAA2Z]

You're welcome

[@ElectromecanicaIndustrial]

really impressive

[@VBAA2Z]

thanks!

[@ElCidPhysics90]

Why do you add 1 to Imgpointer at the beginning of the loop? Causes two problems: 1) myImg(1) is never hit because Imgpointer starts at 1 but then is incremented before use. Therefore, it starts at myImg(2) 2) You’ll get an index out of bounds on the last run because the value will be Me.Controls.Count +1, which is larger than number of controls.

[@VBAA2Z]

Thanks for pointing that out. Much appreciated!

[@ElCidPhysics90]

@@VBAA2Z you’re welcome. Your work is really good. Very impressive interfaces.

[@elderbianco9850]

Muito bom o video

[@VBAA2Z]

thanks!

[@Alexa-zo2ze]

thank you very much for your guides :D

[@VBAA2Z]

You're most welcome. thanks for watching.

[@tilakpun8791]

Grade sir Form Nepal

[@VBAA2Z]

thanks!

[@user-dp5xg7wf2b]

This is amazing

[@VBAA2Z]

thanks!

[@mgpkumar9190]

Sir, Simply Your Channel is Awesome, Could you post any other Treeview Projects at your earliest?

[@VBAA2Z]

Check this out. kzbin.info/www/bejne/fYfcnIWircuthqs

[@zarkotripunovic7507]

This is great

[@VBAA2Z]

Thanks Zarko. Do not forget to subcribe for upcoming videos.

[@DanijelBlasko]

u are amazing !

[@VBAA2Z]

thanks!

[@cristianluisteixeirafrc8435]

just wonderful

[@VBAA2Z]

Thanks Cristian

[@cebuhomesfinder8901]

Hi! where is the prior video you are referring to at 8:10 ? where you are copying the code? thanks!

[@VBAA2Z]

That'll be E01. Please check playlist

[@itrajat09]

awesome tutorial!!!

[@VBAA2Z]

Glad you liked it!

[@OfficewithAtiq]

Attractive video....

[@boostyourskill8525]

Hi Guy, Good job, You did the very good job. Thanks so much. I want to have a complete courses about UX design with userform in vba. show me how ?

[@VBAA2Z]

Thanks! Check out full list here kzbin.info/www/bejne/pmqWe4WgiauKo8U

[@pundalikpatil492]

Not able to download. Not getting email in spam or any other folder for past few hours. Please suggest

[@HungNguyen-kp8yu]

this is awsome

[@VBAA2Z]

thanks

[@DM-hn4yx]

At the beginning you say that all project files will be made available free of charge. I went to link for downloads and I couldn't find the file for this project. Is it available or am I missing something?

[@VBAA2Z]

Hi Dana, to promote code yourself, some tutorial source code downloads are discontinued. Please let me know if you're stuck / need help, I will respond as soon as possible. FYI - In UI UX-18, there are 10 free UI templates download with various examples including the web effects on UI Controls.

[@JJpleex]

What if I want to apply the class module to some images but not all images? How do I define only a specific subset of images?

[@VBAA2Z]

perhaps tag objects using the properties

[@enverkucukkurt]

hi sir. Where can we download this file.? because We cannot complete the tutorial because you did not write the loading codes one by one. I am watching all of your courses. but I cannot get dummy codes for the example you prepared before. please help me sir. ı want to learn so much thank you

[@VBAA2Z]

Hi Enver, thanks for watching. UI load codes can be downloaded free using the below. UI UX-18: kzbin.info/www/bejne/eZrEXniFa7CjfKM UI UX-1: kzbin.info/www/bejne/pmqWe4WgiauKo8U DatePickers: kzbin.info/aero/PLo0aMPtFIFDopFihQsTiSMjaym-Hin5u5

[@enverkucukkurt]

@@VBAA2Z thank you for your kindness but I cant find your project id so I can't create a record. thank you

[@VBAA2Z]

any of below 022 VBA UI UX-1 023 VBA UI UX-18 026 DatePickerX

[@rodrigoperez9664]

Love u

[@VBAA2Z]

thanks!

[@roelpanis8711]

How can create a Menu Bar for my VBA Form? Thanks in advance...

[@VBAA2Z]

Please refer to this video kzbin.info/www/bejne/qoKkpISkht6sptE

[@paulforster6873]

where did you get colorspy from please

[@VBAA2Z]

I downloaded this from silveragesoftware site but looks like they don't have it any more. but try googling it there are many other spy which does the same. Else please let me know I'll upload my copy in drive.

[@jimtaylor4813]

Can I create a spreadsheet in excel and use vba to make it look like a database program? Not sure if I am using the right terminology. I want the user to click an icon on the desktop and it opens like a real program with a UI and not look like the spreadsheet. Does this make sense?

[@VBAA2Z]

You can write small vb script (add this in desktop) and let the program open your app in new session. sample: if this helps. Create notepad, add below code, save as filename.vbs, close it, to test open double click on file. Set objExcel = CreateObject("Excel.Application") Set objWorkbook = objExcel.Workbooks.Open("C:\test.xls") objExcel.Application.Visible = True

[@lucioaires1711]

Encontrei aqui o que tanto procurava.

[@VBAA2Z]

Gracias Lucio

[@ephremmesele5239]

I couldn't find the code.

[@VBAA2Z]

You can download here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html

[@user-dp5xg7wf2b]

❤

[@VBAA2Z]

Thanks!

[@abdulazizalghamdi4340]

@13:20, I tryed to apply this code on MSAcess form but not works!

[@VBAA2Z]

I'll be starting App build and UI in Access soon. I'll talk about these topics too

[@abdulazizalghamdi4340]

@@VBAA2Z Thanks!

[@cristianluisteixeirafrc8435]

do you have a website?

[@VBAA2Z]

here's link to blog - vbaa2z.blogspot.com/

[@iwestarmy]

Obj.Tag = "addEff" is returning a subscript out of range error 9 any ideas? Ill remove it and it all works again Private Sub UserForm_Initialize() Dim Obj As Object, IMgpointer As Long ReDim myIMG(1 To Me.Controls.Count) For Each Obj In Me.Controls If TypeName(Obj) = "Image" And Obj.Tag = "addEff" Then IMgpointer = IMgpointer + 1 Set myIMG(IMgpointer) = New cls_Ctrl Set myIMG(IMgpointer).aImage = Obj End If End If Next Obj ReDim Preserve myIMG(1 To IMgpointer) End Sub

[@VBAA2Z]

possible object you're referring to does not exist please recheck

[@ElCidPhysics90]

I wonder if the Imgpointer +1 shouldn’t appear after the set function. Looks like it will be out of index because the add is before it’s used.