|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/create-your-own-app-in-excel/
课程评论：没有评论
**课程名称：在 Excel 中创建你自己的应用程序** **课程概述：** 本课程将深入探讨 Excel 中一项强大而高级的功能——用户窗体（UserForms）。通过用户窗体，你可以利用 VBA（Visual Basic for Applications）创建 Excel 宏来实现自动化。用户窗体是你创建的自定义表单，可用于补充和交互你的工作表，甚至在某些情况下完全替代与工作表的直接交互。 通过在本课程的学习，你将能够创建带有各种交互元素的自定义表单，例如： * **输入字段：** 允许用户输入数据。 * **下拉列表：** 让用户从预设选项中进行选择。 * **复选框：** 用于多选或布尔值选项。 * **命令按钮：** 触发特定的操作。 这些自定义表单可以使不熟悉直接在 Excel 工作表中操作的用户，通过这些简化的界面来完成任务，从而最大限度地减少他们与工作表的交互。 **课程重点：** * **用户窗体组件：** 详细介绍用户窗体中可包含的各种组件及其功能。 * **数据验证：** 重点讲解确保用户输入数据有效性的各种方法和步骤。 **先修要求：** * **扎实的 Excel 操作知识。** * **良好的 VBA 宏知识。** **推荐预习课程：** * 如果你需要巩固 Excel 基础和 VBA 技能，可以先学习“Excel 入门到进阶”课程。 * 另外，“Excel 自动化”课程也能帮助你打下坚实基础。
UserForms is an advanced and powerful feature in Excel that allows for automation through the creation of Excel macros using VBA (Visual Basic for Applications). Userforms are custom forms that you can create to complement and interact with your worksheet, in some cases your userforms can completely replace interaction with your worksheet. With userforms you can create custom forms with fields where input values can be selected from a dropdown, or checkboxes, create command buttons etc. Such forms can be created for those who are not comfortable working on an Excel sheet thereby making their interaction with excel to the bare minimum. In this course, we take you through the various components that can be included in a custom form and most importantly we cover the various steps whereby you can ensure that data entered is always validated. Needless to say to take this course you need a good working knowledge of Excel and VBA macros. If you would like to brush up your Basic Excel and VBA skills you can take our course on Excel for Beginners to Intermediate and our Excel Automation course.
