Join Curt Frye for an in-depth discussion in this video Declaring variables and requiring declaration before use, part of Learning VBA in Excel.
The designers of the VBA programming language understood that many of the users…who create their own code will not be professional programmers.…Rather than enforcing some of the best practices, such as naming all of your…variables before you use them in your code,…the VBA language lets you create variables in the middle of a subroutine, or a…function, without declaring them earlier.…It's tempting to use that flexibility to avoid declaring your variables, but it…can lead to problems.…So I'll just show you the code that I'm using for this example, and what this…code does is calculate a commission at a rate of 5% based on the sale, whatever…value is in the active cell on the active sheet in the workbook, and then it…rounds that value to two decimal places, so it looks like a dollar value.…
If you want to declare a variable at the top of your code, then you can type the…Dim keyword, Dim stands for dimension or to give something dimension, and then…you type the name of the variable.…In this case, we'll have curValue, and then you need to give it its type.…
- Working in the Visual Basic Editor
- Adding code to a macro
- Creating, exporting, and deleting code modules
- Declaring and using variables
- Managing variable scope
- Defining arrays
- Managing workbooks and worksheets with VBA
- Repeating tasks with loops
- Debugging VBA code
- Cutting, copying, and pasting cell data
- Running and triggering event procedures
Skill Level Advanced
Excel 2016: Power Query (Get & Transform)with Oz du Soleil1h 49m Intermediate
1. Introducing Visual Basic for Applications (VBA)
2. Defining Variables, Constants, and Calculations
3. Adding Logic to Your VBA Code
4. Debugging Your VBA Code
5. Managing Workbook Elements and Data in VBA
6. Adding Advanced Elements to Your Workbook
7. Using Excel Events in Your VBA Code
8. Putting It All Together
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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.