【Excel VBA 教学视频】Excel with Microsoft Excel VBA User Forms
Excel with Microsoft Excel VBA User FormsLearn to Create and Program Microsoft Excel VBA User Forms like a Pro
MP4 | Video: AVC 1280x720 | Audio: AAC 44KHz 2ch | Duration: 3.5 Hours | 463 MB
Curriculum
Section 1: Quick Course Introduction
Lecture 1 Introduction
Lecture 2 Exercise Files - Download these Files
Section 2: Project #1 - Building a User Interface with an Excel VBA UserForm
Lecture 3 Microsoft Excel VBA Project #1 - Introduction
Lecture 4 Project #1 - Building the Excel VBA UserForm
Lecture 5 Project #1 - Adding Controls to the Excel UserForm
Lecture 6 Project #1 - Exercise - Adding Controls to the UserForm
Lecture 7 Project #1 - Working with the Control's Properties
Lecture 8 Project #1 - Exercise - Working with UserForm Control Properties
Lecture 9 Project #1 - Adding Excel VBA Code to the UserForm's Events
Lecture 10 Project #1 - For... Next... Loop Populating a ComboBox
Lecture 11 Project #1 - Control Default Value
Lecture 12 Project #1 - Call Start and End Time Buttons
Lecture 13 Project #1 - Displaying the Excel VBA UserForm to the User
Quiz 1 Project #1 - QUIZ - Building a User Interface with Excel VBA UserForms Quiz
Section 3: Project #2 - Connecting the UserForm to a Worksheet for Data Entry
Lecture 14 Microsoft Excel VBA Project #2 - Introduction
Lecture 15 Project #2 - Select Worksheets Dynamically on Submit
Lecture 16 Project #2 - Transfer Data from UserForm to Worksheet List
Lecture 17 Project #2 - Calculating Data in VBA
Lecture 18 Project #2 - Generate a Unique Call Log Record ID Procedure with VBA
Lecture 19 Project #2 - Exercise - Working with Excel VBA ARRAYS
Lecture 20 Project #2 - Call Generate Call ID Procedure from UserForm
Lecture 21 Project #2 - Vaildating Data Entry in the UserForm
Lecture 22 Project #2 - Clearing the Form
Quiz 2 Project #2 - Quiz
Section 4: Project #3 - Print Call Log Report
Lecture 23 Microsoft VBA Project #3 - Introduction
Lecture 24 Project #3 - Creating the Print Report Excel VBA UserForm
Lecture 25 Project #3 - Exercise - Setting Properties of the UserForm Controls
Lecture 26 Project #3 - Creating a New Excel Workbook with VBA
Lecture 27 Project 3 - Loop Through all Worksheets in Workbook
Lecture 28 Project #3 - Pasting Data into a New Excel Workbook
Lecture 29 Project #3 - A Little Clean Up with VBA
Lecture 30 Project #3 - Exercise - Close Button VBA
Lecture 31 Project #3 - Exercise - Creating the Print Report Button
Quiz 3 Project #3 - Quiz
Section 5: Project #4 - Current Call Stats
Lecture 32 Microsoft VBA Project #4 - Introduction
Lecture 33 Project #4 - Exercise - Build Call Stats Excel UserForm
Lecture 34 Project #4 - Exercise - Setting Properties of UserForm Call Stats
Lecture 35 Project #4 - Create Temporary Stats Worksheet
Lecture 36 Project #4 - Create Temp Sheet Continued
Lecture 37 Project #4 - Calculate Call Stats with VBA on Temporary Worksheet
Lecture 38 Project #4 - Initialize Call Stats UserForm
Lecture 39 Project #4 - Exercise - Refresh and Close Buttons
Lecture 40 Project #4 - Email Stats with VBA and Outlook
Lecture 41 Project #4 - Exercise - Call Stats Worksheet Button
Section 6: Congratulations and Bonus
Lecture 42 Congratulations! You've Completed the Course
Lecture 43 BONUS! Check out my other Courses on Udemy 多谢楼主分享 感谢楼主分享 谢谢您的分享!
页:
[1]