From the course: Access: VBA
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Add comments to your code
- It takes even the most skilled VBA programmers some time to examine an unfamiliar workbooks code and learn how it operates. Whether your viewing a new workbook or one that you created some time ago you'll find that adding comments to the code helps you understand its operation much more quickly. In this movie I will show you how to add a comments to your code. I am working in the course database and I'll push Alt F11 to move to the visual basic editor. Once here, I can insert a code module. So, I will click insert and then module. And there we go. I'll start by creating a fairly straight forward subroutine so I'll just type sub and then name Dbase, followed by left and right parenthesis. And I am not emphasizing anything about the subroutine, I just need something to work with so I will just sort of gloss over what I am creating. So I will go there. And then let's say that it's message box and then in double quotes the prompt will be this is the customer database, period, and a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
(Locked)
Introduction to object-oriented programming1m 59s
-
(Locked)
Examine the Access object model4m 57s
-
(Locked)
Work in the Visual Basic Editor3m 52s
-
(Locked)
Create, export, and delete code modules5m 47s
-
Create a subroutine5m
-
(Locked)
Create a function5m 26s
-
(Locked)
Add comments to your code4m 15s
-
(Locked)
Run a VBA procedure5m 7s
-
(Locked)
-
-
-
-
-
-
-
-
-