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!
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
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.
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.
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?
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.
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?
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
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
Hi Enver, thanks for watching. UI load codes can be downloaded free using the below. UI UX-18: ua-cam.com/video/Cia-EO6KpFA/v-deo.html UI UX-1: ua-cam.com/video/p93JRjTFWmc/v-deo.html DatePickers: ua-cam.com/play/PLo0aMPtFIFDopFihQsTiSMjaym-Hin5u5.html
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
Nice work. No one would believe that this UI design is running on VBA.
thanks!
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!
Great to hear!
Hands down brother! You have made VBA userform great again. Keep doing the good work.
Adding effects looks fab 👏👏 and this is the first time I’m learning how useful is creating Class Object. This is superb and informative.
the attention to detail is amazing!
Thanks!
Glad I came across vast array of VBA amazing tutorials. Thank you!
You're very welcome!
Best usage of class I have seen so far :) thank you for great tutorial!
Glad it was helpful!
Amazing work vbaa2z. thanks for sharing your knowledge
Thanks for watching!
excellent, Very useful video, I have never seen this kind of userform designed like this. Thank you.
You are welcome!
This responsive forms are so cool. Thanks for sharing
Glad you like them!
this is best VBA channel. thank you sirji
thank you!
Very useful video, i have never seen this kind of userform design like this. Thank you sir
The best VBA channel! 👏
Thanks for your compliment :)
Very useful channel for VBA , nice video again woo.. nice video,
excelent, Very useful video, i have never seen this kind of userform design like this. Thank you.
You are welcome!
Your videos are incredible. Thank you so much
Say
You are so welcome!
It's a wonderfull and amazing job ! I'm like ejected from m'y chair🤩🤩
Hi Messame, thank you! 😊
It looks very beautiful. Looking forward to next video. Thanks
Отличное объяснение необходимости классов! Прости и понятно и, главное, очень полезно!
Happy to hear that!
thanks for watching.
Another great video. Thank you so much.
Thanks for watching!
brilliant and super creative! thank you
Thank you! Cheers!
Starting to make my own project and this is a great help.thanks.
Glad it was helpful! thanks for watching
Vba A2Z Amazing channel.
thank you
Thanks for all tips. Try to redo myself !
Perfect!
Very useful 👍good job 👍keep going 👍
Love your videos keep going 🤗🤗🤗
Very nice. I love the lesson on CLASSES
Thank you! 😃
Appreciate knowledge sharing and effort. Great job. Thanks again
Amazing! I'm so glad I found this channel.
I have to agree with follow viewers, this is absolutely fabulous. thank you
Another awesome video
Thanks for the visit
Hi! where is the prior video you are referring to at 8:10 ? where you are copying the code? thanks!
That'll be E01. Please check playlist
this is awesome. Thank you so much
You're very welcome!
Thanks for another lovely day
My pleasure!
this is fab! great work
Glad you like it!
Awesome 👍
Thank you! Cheers!
Learning a lot from this great tutorials. Thanks again!
Glad you like them!
Very informative. Thanks
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
Thanks for the tips!
Thanks for sharing your knowledge.
My pleasure! thanks for watching
Thank you for very useful video
Glad it was helpful!
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?
Please check out this video ua-cam.com/video/QNYpiSTOX7w/v-deo.html
This can be easily implemented in any other projects
Nice one☝
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.
Thanks for pointing that out. Much appreciated!
@@VBAA2Z you’re welcome. Your work is really good. Very impressive interfaces.
Very nice!
Thank you! Cheers!
awesome, thanks!
You bet!
Fab. Keep it up!
Great 👍
Thank you! Cheers!
great job. keep going :)
Thank you! 😃
brilliant work!
Thank you! Cheers!
Wow. You are brilliant
Thank you! Cheers!
Great ideas.
Thank you! 😊
Amazing, Very Beautifull
Thank you! Cheers!
brilliant sir
thanks!
Like it!
Thank you! Cheers!
Sir, Simply Your Channel is Awesome, Could you post any other Treeview Projects at your earliest?
Check this out.
ua-cam.com/video/GVykRlxfzPI/v-deo.html
Very good
Thanks
superb
Thank you! Cheers!
excellent
Thank you! Cheers!
Nice Video
Thanks
nice one
Thanks for the visit
good project
thanks
Not able to download. Not getting email in spam or any other folder for past few hours. Please suggest
You know, I found a lesson I wanted to learn from you, but when I finish that, I don't where to continue!
I highly recommend VSTO Series or ADO Series.
ua-cam.com/play/PLo0aMPtFIFDqaRyd0KZ0DLXFD3rfhI4SU.html
awesome tutorial!!!
Glad you liked it!
This is amazing
thanks!
@13:20, I tryed to apply this code on MSAcess form but not works!
I'll be starting App build and UI in Access soon. I'll talk about these topics too
@@VBAA2Z Thanks!
Muito bom o video
thanks!
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?
perhaps tag objects using the properties
Thanks
thank you
You're welcome
really impressive
thanks!
thank you very much for your guides :D
You're most welcome. thanks for watching.
u are amazing !
thanks!
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 ?
Thanks!
Check out full list here ua-cam.com/video/p93JRjTFWmc/v-deo.html
just wonderful
Thanks Cristian
Grade sir
Form Nepal
thanks!
This is great
Thanks Zarko. Do not forget to subcribe for upcoming videos.
this is awsome
thanks
How can create a Menu Bar for my VBA Form? Thanks in advance...
Please refer to this video
ua-cam.com/video/tQAsQnQyypo/v-deo.html
where did you get colorspy from please
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.
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?
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.
Attractive video....
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?
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
I couldn't find the code.
You can download here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
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
Hi Enver, thanks for watching. UI load codes can be downloaded free using the below.
UI UX-18: ua-cam.com/video/Cia-EO6KpFA/v-deo.html
UI UX-1: ua-cam.com/video/p93JRjTFWmc/v-deo.html
DatePickers: ua-cam.com/play/PLo0aMPtFIFDopFihQsTiSMjaym-Hin5u5.html
@@VBAA2Z thank you for your kindness but I cant find your project id so I can't create a record. thank you
any of below
022 VBA UI UX-1
023 VBA UI UX-18
026 DatePickerX
do you have a website?
here's link to blog - vbaa2z.blogspot.com/
Love u
thanks!
Encontrei aqui o que tanto procurava.
Gracias Lucio
❤
Thanks!
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
possible object you're referring to does not exist please recheck
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.