Thanks a lot. But please advise how to activate close button on this userform(not by using unload option. The real close button on the right top corner)?
Simple add below code to your form. It'll run when the form close. Same as close button is clicked. Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer) 'Your code here End Sub
Good day, thank you so much for the lesson. I have a question. Apart from saving images in a different separate folder, is it possible to have those images save in a worksheet which you can refer to?
I really like what you do. Just one question, instead of using multiple "if then ... end if" statements, why don't you use the "select case" "case 123" ..."end select" statement? I have always found this both easy to understand, easy the maintain and easy to expand!!! I am looking forward to the rest of the series!
Hi Will, thanks for your comment and suggestion. In these UIUX videos, I try to keep things as simple as possible. I'll definitely cover more videos around writing efficient codes and options to optimize and make stable code. Please do not forget to subscribe for upcoming videos and we'll discuss more in upcoming videos. Cheers!
Hello everyone, Pls guide. I've 500 names listed in a column. Now i want to create userform controls (with these names, labels, txtbx, combobox) and save them permanently on userform. I am able to create them on runtime but cant find how to save them. Also these controls to be created within a FRAME, which is on MULTIPAGE.
Don't worry, mastering the skills of creating beautiful VBA userforms is absolutely possible with dedication and practice! Here are a few steps you can take: 1. Study UI/UX principles: Familiarize yourself with user interface and user experience design principles. Understand the concepts of layout, color theory, typography, and usability. 2. Explore design inspiration: Look for design inspiration from various sources such as websites, mobile apps, and other software interfaces. Analyze and understand what makes them visually appealing and user-friendly. 3. Learn VBA userform controls: Get acquainted with different userform controls available in VBA and their functionalities. Experiment with them to understand how they can be combined to create effective user interfaces. 4. Practice design techniques: Start with simple userforms and gradually challenge yourself with more complex designs. Experiment with different layouts, color schemes, and fonts to create visually pleasing interfaces. 5. Seek feedback and iterate: Share your designs with others and seek feedback. Take constructive criticism positively and use it to improve your skills. Iterate and refine your designs based on the feedback received. 6. Learn from tutorials and examples: Explore online tutorials, articles, and examples that demonstrate VBA userform design techniques. Learn from experienced designers and developers who have shared their knowledge and expertise. Remember, mastering any skill takes time and effort. Keep practicing, stay curious, and never hesitate to experiment. With persistence, you'll be able to create beautiful VBA userforms that impress others. Best of luck on your learning journey!
Please find the link below. After submitting the request be sure to check spam folder too. vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
2 years later and this video is still very much relevant. Thank you
thanks!
I am so glad you put this tutorial/playlist together. Very helpful thank you
Glad it helped!
What a great tutorial to land on. Excellent and precise.
Glad it was helpful!
Your explication are very easy to understand, even for start Developper, very Interresting and thank you for your sharing.
You're very welcome!
This is excellent sir. looking forward to next video
Clear and simple. Excellent
Glad it was helpful!
Thanks a lot.
But please advise how to activate close button on this userform(not by using unload option. The real close button on the right top corner)?
Simple add below code to your form. It'll run when the form close. Same as close button is clicked.
Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
'Your code here
End Sub
Very innovative utilization of Multi page
Thanks
Good day, thank you so much for the lesson. I have a question. Apart from saving images in a different separate folder, is it possible to have those images save in a worksheet which you can refer to?
check this out th-cam.com/video/ck3NIB-TzR0/w-d-xo.html
I like your video's it is very helpful and easy to understand.
Glad to hear that!
Excellent. Thorough. Easy to follow.
Glad it was helpful!
Where can I download the file. its not listed in the link. An by the way SUPER TUTORIAL
Excellent Video!
Thank you very much!
This is great! Thank you for sharing this :)
Glad you enjoyed it! thanks for watching
great video - this exactly what I needed - thanks!
Great to hear!
I really like what you do. Just one question, instead of using multiple "if then ... end if" statements, why don't you use the "select case" "case 123" ..."end select" statement? I have always found this both easy to understand, easy the maintain and easy to expand!!! I am looking forward to the rest of the series!
Hi Will, thanks for your comment and suggestion. In these UIUX videos, I try to keep things as simple as possible. I'll definitely cover more videos around writing efficient codes and options to optimize and make stable code.
Please do not forget to subscribe for upcoming videos and we'll discuss more in upcoming videos. Cheers!
Of course this is very helpful and informative. Thanks sir
Very useful, great job !
Thanks!
Mind blowing. Thank you so very much
Thanks and welcome
brilliant. thank you for sharing this very helpful tips.
Please make report from use form like crystal report with many page and can print
thanks for the idea
Congratulation Sir, But in my machine is error to "Private Declare Function GetWindowLong Lib "user32"". how to resolve?
Thanks David.
Are you using 64-bit Excel? if so please check below link.
vbaa2z.blogspot.com/2020/04/compile-error-code-in-this-project-must.html
hi very great job, i don't found the file to download for practice again
if you're looking for free download please check th-cam.com/video/Cia-EO6KpFA/w-d-xo.html
Great work bro.. Many thanks for sharing..
Thanks and welcome
thank you, really it is very important guide for us
You are most welcome. thanks for watching
lots to catch up, thanks
No worries
Wow i love it!
Yay! Thank you!
Thanks for your tutorials
Hello everyone,
Pls guide.
I've 500 names listed in a column. Now i want to create userform controls (with these names, labels, txtbx, combobox) and save them permanently on userform.
I am able to create them on runtime but cant find how to save them.
Also these controls to be created within a FRAME, which is on MULTIPAGE.
I'll be uploading videos regarding input screen in some time this afternoon please subscribe and watch out.
Also if you have a sample, feel free to email at vbaa2z.team@gmail.com
th-cam.com/video/csUhqCN0CBI/w-d-xo.html
This video might help you. Check it out
Great videos - tons of info & tricks.. i have lots to catch up on
Glad you like them!
this is very helpful. thank you sir
How can I learn and master the skills of making beautiful VBA userforms like yours. 😢😢😢
Don't worry, mastering the skills of creating beautiful VBA userforms is absolutely possible with dedication and practice! Here are a few steps you can take:
1. Study UI/UX principles: Familiarize yourself with user interface and user experience design principles. Understand the concepts of layout, color theory, typography, and usability.
2. Explore design inspiration: Look for design inspiration from various sources such as websites, mobile apps, and other software interfaces. Analyze and understand what makes them visually appealing and user-friendly.
3. Learn VBA userform controls: Get acquainted with different userform controls available in VBA and their functionalities. Experiment with them to understand how they can be combined to create effective user interfaces.
4. Practice design techniques: Start with simple userforms and gradually challenge yourself with more complex designs. Experiment with different layouts, color schemes, and fonts to create visually pleasing interfaces.
5. Seek feedback and iterate: Share your designs with others and seek feedback. Take constructive criticism positively and use it to improve your skills. Iterate and refine your designs based on the feedback received.
6. Learn from tutorials and examples: Explore online tutorials, articles, and examples that demonstrate VBA userform design techniques. Learn from experienced designers and developers who have shared their knowledge and expertise.
Remember, mastering any skill takes time and effort. Keep practicing, stay curious, and never hesitate to experiment. With persistence, you'll be able to create beautiful VBA userforms that impress others. Best of luck on your learning journey!
Superb
Thank you! Cheers!
Where can I get the training file codes?
pamaitech.com
Fantastic content!!!!
Glad you enjoyed it
Awesome!
Thank you! Cheers!
where to download project file of the work of this video
please check here vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
Very nice video but I am unable to find the id of the project so please help me out
Please check video description
@@VBAA2Z I have seen but I don't got the id. Please help me out in the matter.
What is .pptm?
A PPTM file is a macro-enabled presentation created by Microsoft PowerPoint
Amazing i don't found the link to download this file m'y english is poor 😟
Please find the link below. After submitting the request be sure to check spam folder too.
vbaa2z.blogspot.com/2020/12/you-can-support-vba-a2z-by-simply.html
@@VBAA2Z I just realized that this isn't part of the free projects. Do we have to buy one in order to access this file?
thank youuuuu you saved me
Glad to hear that. Please find info in the description
This so clever!
Guess that's a compliment :)
Un grand merci
très bienvenu
great work
Thanks!
Thank you
You're welcome
Amazing!
Thank you! Cheers!
thanks
Welcome
Show!
Super!
not bad... not bad...
Thanks
HEY I NEED HELP
Sure please let me know here in comment section or via email
@@VBAA2Z my email Is gabbolglez@live.com
Do you have the project?
nice！
Thank you! Cheers!