Author
Curt Frye
Released
1/22/2019- Recall the limitations of a subroutine.
- List the steps taken to record a macro with a PivotTable.
- Identify the keyword used to resize an array.
- Explain what a VBA watch does.
- Name the Excel function that uses the distance from one cell to another.
- Determine how to delete a worksheet.
- Identify the type of variables that can be used in more than one subroutine.
- Summarize the effects of assigning a macro to a function key.
Skill Level Advanced
Duration
Views
- [Curt] Microsoft Excel is a powerful program, one you can make even more powerful by creating custom solutions using Excel Visual Basic for applications. In this course, I'll provide detailed examples with sample code to show you how to get the most out of Excel using Excel VBA. I'm Curt Frye. Join me at LinkedIn Learning for an introduction to Excel VBA that will let you unlock the power of your company's data.
-
Introduction
-
What you should know1m 26s
-
1. Visual Basic for Applications
-
Set VBA project properties3m 55s
-
Create a subroutine4m 44s
-
Create a function4m 57s
-
Run a VBA routine6m 8s
-
Add code to a recorded macro3m 41s
-
2. Defining Variables, Constants, and Calculations
-
Manage variable scope3m 54s
-
3. Adding Logic to Your VBA Code
-
4. Debugging Your VBA Code
-
Set breakpoints in your code3m 32s
-
Watch a value in a routine3m 30s
-
5. Managing Workbook Elements and Data in VBA
-
Write a value to a cell4m 9s
-
Find values in cells4m 35s
-
Concatenate text strings5m 7s
-
Return part of a string3m 57s
-
-
6. Adding Advanced Elements to Your Workbook
-
7. Using Excel Events in Your VBA Code
-
8. Putting It All Together
-
Conclusion
-
Further information1m 19s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Dive into using VBA in Excel