|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/excel-vba-in-depth-userforms/
课程评论：没有评论
Coursera Excel VBA In-Depth USERFORMS Series7 课程总结 本课程面向掌握了数组、循环和变量等基础知识，并希望通过创建高级用户窗体（Userforms）来提升VBA技能的开发者。课程涵盖从用户窗体设计到编程的各个方面，强调了循环、If语句、变量和集合在用户窗体中的实际应用。 **核心内容概览：** * **用户窗体基础与进阶：** 深入讲解作为VBA重要组成部分的用户窗体，不仅仅停留在基础信息，更侧重于将学到的循环、If语句、变量和集合知识融会贯通。 * **实用项目驱动学习：** 提供大量MIS项目和小型实用的用户窗体项目，例如使用循环、If语句和数组实现列表框（ListBox）中项目的上下移动。 * **控件详解：** 全面讲解用户窗体中的各种控件，包括组合框（ComboBox）、列表框（ListBox）、文本框（TextBox）、标签（Label）、命令按钮（CommandButton）、日期时间日历（DateTime Calendar）、框架（Frame）等，并从零开始详细解析。 * **事件驱动编程：** 深入探讨Change、Click、Initialize、Close和Update等用户窗体事件，详细解释不同事件的选择原因及应用场景，并通过实际案例进行演示。 * **用户窗体调试技巧：** 教授用户窗体特有的调试方法，解决无法直接使用F8进行调试的问题。 * **变量作用域管理：** 讲解全局变量在用户窗体中的使用，并阐述为何局部变量或模块级变量有时会失效。 * **数据导航与联动：** 演示如何创建“移至下一条”按钮以逐条查看Excel数据，以及如何实现组合框与列表框的联动（例如：在组合框选择文件夹后，列表框显示该文件夹下的文件）。 * **高级应用：** 介绍如何利用FileSystemObject等Scripting库类在用户窗体中实现高级功能，并提供进阶水平的项目和练习，附带现成代码。 * **特色项目：** 课程包含一个“追踪凭证”（Tracking Voucher）项目，旨在提供极具趣味性和高度进阶的自动化体验。 总而言之，本课程致力于通过实践和实际项目，帮助学习者掌握用户窗体的设计与编程，从而成为更出色的VBA开发者。
Course is focusing on basic level developers who know arrays. loops and variable pretty well and now want to take their knowledge to next level by creating super advance USERFORMS which uses all these topics.From designing to programming and what things to be kept in mind while making user-forms. Collection loops structure in User-forms and their use practically.User-forms are very important part of VBA and one cannot be known as a great programmer if he or she does not know user forms. This is not just a basic level information tutorial on FORMS but you shall see here loops, if functions, variables use and collections loops is applied. After-all. there is nothing better than practical learning so i have great MIS Projects as well for you.Many good short projects for you on user forms. For eg. How to move up or down the items available in list box using loops, IFs and Arrays.Deep study on controls like Combo box,List box,text box, labels ,Command buttons, date time calendars, frames - everything discussed from scratchUse of forms Events like Change event, Click event, initialize event, Close event and Update events is discussed in detail.Which event should you choose and why. Full explanation by taking practical scenarios.How to debug the Userform coding as you cannot directly debug using F8.See the use of Global variable sin USERFORM and lean why local or module level variables can fail.Create Move next button in forms to see the data one by one coming from excelHow to connect combo box with list box and why. For eg. if i change folder in combo box then my files under that folder should appear in list box.Use Amazing Scripting library classes like fileSystemObject in User forms.Advance level and practical projects and assignments with ready made codes is added as well. Just added a Tracking Voucher project for you, It is super duper fun and highly advance, Enjoy the automation.
