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

[@hwanlee9110]

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

[@VBAA2Z]

thanks!

[@Kinsi-l3c]

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!

[@izotodepuera]

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

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

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

[@dinawangjkiu9712]

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

[@VBAA2Z]

Glad it was helpful!

[@winingchewang2712]

this is best VBA channel. thank you sirji

[@VBAA2Z]

thank you!

[@WeningWang]

Amazing work vbaa2z. thanks for sharing your knowledge

[@VBAA2Z]

Thanks for watching!

[@Kumaranmoljha]

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

[@alexcrown497]

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

[@VBAA2Z]

Happy to hear that! thanks for watching.

[@sidaun9327]

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

[@jimohsuleadekunle5395]

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

[@VBAA2Z]

You are welcome!

[@g1834-c4f]

This responsive forms are so cool. Thanks for sharing

[@VBAA2Z]

Glad you like them!

[@jaspeeg]

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

[@VBAA2Z]

You are welcome!

[@Rahul-sn1wn]

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

[@deisepereira8236]

The best VBA channel! 👏

[@VBAA2Z]

Thanks for your compliment :)

[@mariosantos871]

Very nice. I love the lesson on CLASSES

[@VBAA2Z]

Thank you! 😃

[@Shuiniu-df9ds]

Your videos are incredible. Thank you so much Say

[@VBAA2Z]

You are so welcome!

[@Evadisa-q8h]

Vba A2Z Amazing channel.

[@VBAA2Z]

thank you

[@Nel-vy7nj]

Another great video. Thank you so much.

[@VBAA2Z]

Thanks for watching!

[@JbongjiAlvira]

brilliant and super creative! thank you

[@VBAA2Z]

Thank you! Cheers!

[@wilamdinchawang3484]

Appreciate knowledge sharing and effort. Great job. Thanks again

[@bnancy3699]

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

[@buih2]

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

[@pamchamzell4489]

Love your videos keep going 🤗🤗🤗

[@Kinsuang-m6y]

Thanks for another lovely day

[@VBAA2Z]

My pleasure!

[@JérômeLANCE-c1c]

Thanks for all tips. Try to redo myself !

[@VBAA2Z]

Perfect!

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

[@monsesamme]

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

[@VBAA2Z]

Hi Messame, thank you! 😊

[@susilsxzen-ff1zn]

Thank you for very useful video

[@VBAA2Z]

Glad it was helpful!

[@simplejuan]

Learning a lot from this great tutorials. Thanks again!

[@VBAA2Z]

Glad you like them!

[@Wilmerne]

Thanks for sharing your knowledge.

[@VBAA2Z]

My pleasure! thanks for watching

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

[@kizannbung486]

Very useful 👍good job 👍keep going 👍

[@LankoDora]

this is awesome. Thank you so much

[@VBAA2Z]

You're very welcome!

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

[@IrenaSlws]

this is fab! great work

[@VBAA2Z]

Glad you like it!

[@Mira-kp5di]

Another awesome video

[@VBAA2Z]

Thanks for the visit

[@lamdinliuchewang3610]

brilliant sir

[@VBAA2Z]

thanks!

[@usamanaeem8737]

Wow. You are brilliant

[@VBAA2Z]

Thank you! Cheers!

[@poponaplo3442]

Amazing, Very Beautifull

[@VBAA2Z]

Thank you! Cheers!

[@Jusils]

Awesome 👍

[@VBAA2Z]

Thank you! Cheers!

[@BrainsEatZombies35]

Thanks

[@annanamdau1605]

Nice one☝

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

[@ningsan1054]

Great 👍

[@VBAA2Z]

Thank you! Cheers!

[@7aidoori]

great job. keep going :)

[@VBAA2Z]

Thank you! 😃

[@Sicilia-rn1hc]

awesome, thanks!

[@VBAA2Z]

You bet!

[@anatolyhazan9777]

Great ideas.

[@VBAA2Z]

Thank you! 😊

[@Nphum]

superb

[@VBAA2Z]

Thank you! Cheers!

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

[@Sara-f6e1g]

brilliant work!

[@VBAA2Z]

Thank you! Cheers!

[@narcelioteixeira861]

excellent

[@VBAA2Z]

Thank you! Cheers!

[@elderbianco9850]

Muito bom o video

[@VBAA2Z]

thanks!

[@kingqiabonmai1890]

thank you

[@VBAA2Z]

You're welcome

[@valachibrothers1295]

Very good

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

[@Alexa-zo2ze]

thank you very much for your guides :D

[@VBAA2Z]

You're most welcome. thanks for watching.

[@s.mujtabaalnajjar779]

Very nice!

[@VBAA2Z]

Thank you! Cheers!

[@kinwiliu999]

Fab. Keep it up!

[@tilakpun8791]

Grade sir Form Nepal

[@VBAA2Z]

thanks!

[@wardimagetanyashli6764]

good project

[@VBAA2Z]

thanks

[@ElectromecanicaIndustrial]

really impressive

[@VBAA2Z]

thanks!

[@mehtag7810]

nice one

[@VBAA2Z]

Thanks for the visit

[@cristianluisteixeirafrc8435]

just wonderful

[@VBAA2Z]

Thanks Cristian

[@itrajat09]

awesome tutorial!!!

[@VBAA2Z]

Glad you liked it!

[@victoriaagbenuakinsulire882]

Nice Video

[@VBAA2Z]

Thanks

[@Kingwiliu]

🙏 thanks

[@VBAA2Z]

You’re welcome 😊

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

[@Kinsuang-m6y]

This is amazing

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

[@pundalikpatil492]

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

[@zarkotripunovic7507]

This is great

[@VBAA2Z]

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

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

[@DanijelBlasko]

u are amazing !

[@VBAA2Z]

thanks!

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

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

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

[@stephaneguemo9520]

Like it!

[@VBAA2Z]

Thank you! Cheers!

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

[@HungNguyen-kp8yu]

this is awsome

[@VBAA2Z]

thanks

[@lucioaires1711]

Encontrei aqui o que tanto procurava.

[@VBAA2Z]

Gracias Lucio

[@cristianluisteixeirafrc8435]

do you have a website?

[@VBAA2Z]

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

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

[@OfficewithAtiq]

Attractive video....

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

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

[@Kinsuang-m6y]

❤

[@VBAA2Z]

Thanks!

[@rodrigoperez9664]

Love u

[@VBAA2Z]

thanks!

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