VBA UI UX-5: Create multiple pages within UserForm Interface and link to the menu. Real-life App -E2
HTML-код
- Опубликовано: 6 июн 2024
- 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/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: ruclips.net/user/vbaa2zplaylists
Videos: ruclips.net/user/vbaa2zvideos
#VbaA2z - Наука
2 years later and this video is still very much relevant. Thank you
thanks!
This is excellent sir. looking forward to next video
What a great tutorial to land on. Excellent and precise.
Glad it was helpful!
Of course this is very helpful and informative. Thanks sir
Excellent. Thorough. Easy to follow.
Glad it was helpful!
brilliant. thank you for sharing this very helpful tips.
Clear and simple. Excellent
Glad it was helpful!
great video - this exactly what I needed - thanks!
Great to hear!
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 great! Thank you for sharing this :)
Glad you enjoyed it! thanks for watching
Thanks for your tutorials
Very useful, great job !
Thanks!
Excellent Video!
Thank you very much!
Great videos - tons of info & tricks.. i have lots to catch up on
Glad you like them!
I like your video's it is very helpful and easy to understand.
Glad to hear that!
Wow i love it!
Yay! Thank you!
Mind blowing. Thank you so very much
Thanks and welcome
this is very helpful. thank you sir
Very innovative utilization of Multi page
Thanks
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
Fantastic content!!!!
Glad you enjoyed it
Awesome!
Thank you! Cheers!
lots to catch up, thanks
No worries
Un grand merci
très bienvenu
Superb
Thank you! Cheers!
Amazing!
Thank you! Cheers!
This so clever!
Guess that's a compliment :)
Thank you
You're welcome
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!
great work
Thanks!
nice!
Thank you! Cheers!
thanks
Welcome
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 ruclips.net/video/ck3NIB-TzR0/видео.html
Show!
Super!
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
Where can I download the file. its not listed in the link. An by the way SUPER TUTORIAL
not bad... not bad...
Thanks
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!
Please make report from use form like crystal report with many page and can print
thanks for the idea
hi very great job, i don't found the file to download for practice again
if you're looking for free download please check ruclips.net/video/Cia-EO6KpFA/видео.html
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
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
ruclips.net/video/csUhqCN0CBI/видео.html
This video might help you. Check it out
thank youuuuu you saved me
Glad to hear that. Please find info in the description
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
What is .pptm?
A PPTM file is a macro-enabled presentation created by Microsoft PowerPoint
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.
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?
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?
Having problems with : dt_start.Value = #1/1/2019# and Me.FlatScrollBar1.Min = 2, can you help?
Are you facing issue with these controls, please share more info, I'd be happy to help.
@@VBAA2Z As soon as I load the file it gives me the error "Could not load some objects because they are not available on this machine"
I also have this error: MISSING Microsoft Windows Common Controls 2-6.0 (SP6)
And this one: dt_star.Value - Error: Variable not defined
The form is not equal to video, need video workbook
@@MJLCabral you're right on time. I just published a short video with the link the install package.
All the best!
ruclips.net/video/QGZqjUGhJ1Q/видео.html