Call

We “Call” something when we start to “Run” macro “Code”. Call really means the same as run. Sometimes we call one macro from another macro. If you want to call a macro from a macro you’ll have to think about how you declare your “Variables“. We had some calling going on when we got our user form working. Here’s the code we used to call the user form from within the main body of the macro: UserForm1.Show.

Code

C stands for “Code”. Perhaps without realising it, that’s what you’re getting into here: creating computer code. You’re becoming a coder! If you’re now totally confused about what that might mean, maybe it’s worth having a look at what we’re saying under E for “Excel VBA macro“. Alternatively, if you appreciate that you’re now into coding, have a look at our collection of code examples from this course.

Comments

C is also for “Comments”. It’s a good idea to add comments to your code telling the user what you’re trying to achieve. Comments display as green text in the VBA editor. Create a comment by adding a single apostrophe mark ‘ ahead of the text. Comments are not read as computer code and are ignored by Excel. They’re really handy for your users though!

Custom user forms

C is for “Custom user forms”. They allow you to make reasonably complex dialog boxes to collect up inputs from your users. See “User forms”.

Macros coverage from the financial modelling course

You’re looking at the macros glossary from our course material covering the use of macros in Excel financial modelling.

...join the conversation...

Your email address will not be published. Required fields are marked *