Hello friends,
In this series, I will be covering how to design a Professional User Interface using Microsoft Office Applications (starting with Excel UserForm & Access Forms).
In short, UI focus on creating attractive visual layouts that are responsive and guiding whereas UX focuses more on the user experience. I'll cover both aspects of the designs. I'll show you how to use all inbuilt controls and also teach you how to create custom controls and effects. I'll try to cover many practical examples so you can easily replicate them as per your need.
Playlist link (Enjoy the series and do not forget to subscribe!)
https://www.youtube.com/playlist?list=PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p
Support: https://paypal.me/lpamai
In this series, I will be covering how to design a Professional User Interface using Microsoft Office Applications (starting with Excel UserForm & Access Forms).
In short, UI focus on creating attractive visual layouts that are responsive and guiding whereas UX focuses more on the user experience. I'll cover both aspects of the designs. I'll show you how to use all inbuilt controls and also teach you how to create custom controls and effects. I'll try to cover many practical examples so you can easily replicate them as per your need.
Subscribe Now!
New videos every Weekend!
Like what I do? Donate
Did I help you? Did one of my tutorials save you sometime?
You can say thank you by buying me a cup of coffee, I go through a lot of it.
Help keep Greater Good resources free for everyone. Please donate today.
https://www.youtube.com/playlist?list=PLo0aMPtFIFDoF3QSS_GZUYoHCqLwEPB8p
Support: https://paypal.me/lpamai
If you have any questions/feedback/tutorial request, please you can email me directly vbaa2z.team@gmail.com or comment on respective YouTube Videos (blog comments are not actively monitored).
Link to download entire project materials used within the video can be found within the youtube video description. Please do not forget to subscribe and also share them with your friends.
Check below link to subscribe.
https://www.youtube.com/vbaa2z?sub_confirmation=1
Topics covered so far:
VBA UI UX-1: Build UI using Excel UserForm, Fields with watermark, transparent icons & Buttons
VBA UI UX-2: Add web-like effects to Excel UserForm Controls
VBA UI UX-3: Advanced Autocomplete Suggestions, Predictive search for Excel UserForm
VBA UI UX-4: Create Custom Form with dynamic menu and icon. Real-life App -E1
VBA UI UX-5: Create multiple pages within UserForm Interface and link to the menu. Real-life App -E2
VBA UI UX-6: Data input screen with fields, drop-downs, file Drag Drop feature, custom table
VBA UI UX-7: Autofill textbox fields, dropdown, date controls on UI load
VBA UI UX-8: How to add file drag-drop feature to your UI (UserForm) Interface and upload document
VBA UI UX-9: Design a custom table with scroll bar in Excel Userform, read or write data to it
VBA UI UX-10: Capture UserInput in UserForm and save data to back-end, upload file to Library
VBA UI UX: How to download and use project files and materials. All the best!
VBA UI UX-11: How to install Common Controls. ListView, TreeView, FlatScrollBar, ImageList etc.
VBA UI UX-12: How to add and use Powerful ListView Control in Excel UserForm. Part-1
VBA UI UX-13: How to add and use Powerful ListView Control in Excel UserForm. Part-2
VBA UI UX-14: Advanced VBA Progress Bars for Office applications. 100% Free download
VBA UI UX-15: Advanced drop down menu with image
VBA UI UX-16: How to use powerful TreeView Control in Excel UserForm. Download project for free
VBA UI UX-17: Drag-drop to reorder or move items between UserForm Listbox. Download project for free more to be added
Snapshots for reference below.
UI UX for VBA Developers
Advanced Userform Designs
Custom Forms in Excel
Custom Fields VBA
Custom Table VBA
Effects VBA
Hover Effect VBA
UI
UX
User Interface
No comments:
New comments are not allowed.