Where Do I Put My Code?

Quick reference

• 00:05 Before we start chasing and working with code and what not, the other thing that I
• 00:09 wanna talk about really quickly is where do we actually put our code?
• 00:14 When we start building things there's a lot of different containers that
• 00:17 are available to actually hold things.
• 00:19 So if I were to come and take a look at this work book, for example,
• 00:22 I'm gonna double click on it and
• 00:23 you'll notice that it has only one line in here right now, Option Explicit.
• 00:28 Incidentally, if that line is not showing up here, it's because you did not
• 00:33 go into the Tools Options and say for Require Variable Declaration.
• 00:37 So if you don't have that please check it now and then any new modules or
• 00:40 any new workbooks will automatically have that.
• 00:43 So this is one module, this is a very specific module called a class module.
• 00:47 You're only gonna put code in here if you're directed to do it by
• 00:50 someone, that's it.
• 00:51 That's the only reason.
• 00:52 This is a very special module to do very special things.
• 00:55 Likewise, Sheet 1, Sheet 2, Sheet 3, these are very special modules as well.
• 01:00 Code that goes into this workbook is applicable to the entire workbook.
• 01:05 Code that goes into these specific work sheets, these are containers for
• 01:09 code that runs specifically on that workbook, or on that worksheet rather.
• 01:13 And you might think, well I want all my code to work across the entire workbook,
• 01:16 so I'm going to throw it into this workbook, but that's not the point.
• 01:18 This workbook is for doing things like monitoring events,
• 01:21 like workbook open or closed very specific stuff.
• 01:25 So unless you're directed to put code in there for
• 01:28 any reason you don't wanna actually go there by default.
• 01:31 The same with the individual sheet modules.
• 01:34 You will also notice that there are some other abilities you can get in here,
• 01:37 so right click and
• 01:38 say insert, you will notice we have three different types of modules here.
• 01:42 We have a user form.
• 01:43 This will actually show up with an individual user form or whatnot.
• 01:46 They're very tempted to start jumping into but these are very complex little pieces.
• 01:50 They're actually outside of the scope in this course completely.
• 01:53 You don't want to put your code in here until you've had some experience working
• 01:56 with programming and understand how these things work,
• 01:58 because these have multiple containers too.
• 02:00 The visual layer and
• 02:01 there's a coded layer that goes with them and they kinda complicated.
• 02:04 There is another one
• 02:06 that you'll see occasionally which is called a class module.
• 02:09 Class modules look a little bit different, they actually look like the icon for
• 02:13 some of the stuff that you'll see inside the object browser.
• 02:17 So if I were to go back in you'll notice that we have a bunch of these individual
• 02:20 classes and that's what this looks like as well.
• 02:23 Class modules are quite advanced.
• 02:25 You don't want to be starting there so don't be putting any code in there until
• 02:28 you know exactly what's going on with this thing.
• 02:30 This is something that you're generally not gonna run into as
• 02:34 you start your coding journey.
• 02:35 It's only as you actually pick up other projects from other people and
• 02:38 my biggest piece of advice to you would be if you run into something that
• 02:41 has one of these things in, don't mess with it, get some help.
• 02:44 And that's one of the big things that I really, really encourage you to do.
• 02:49 So I told you lots of places where you're not gonna put code.
• 02:51 But I haven't told you anywhere where you are.
• 02:54 This little container here with modules, this is for you.
• 02:57 This is all about you.
• 03:01 You can right click and you can say Insert and
• 03:03 you can put in as many modules as you want.
• 03:06 And these modules are where you're going to contain your code.
• 03:09 If you notice in Module 1, this is where we actually recorded those when we start
• 03:14 recording code everything went into module one by default for the row full vertical.
• 03:19 If I shut excel down and I opened up again and
• 03:22 I do a new recording it's gonna go into Module 2.
• 03:26 Or in this case, it will probably actually go into module 4.
• 03:29 It will create a new module for me right away.
• 03:31 Every piece of code that I record throughout that session of Excel will then
• 03:35 end up getting stuffed into the same code module.
• 03:38 That's not a big deal.
• 03:39 I can cut, copy, and paste this code anywhere I want.
• 03:42 But the key part here is to try to group it here for you.
• 03:44 So these modules, anything under the module area, these are for you.
• 03:48 Play with them till your hearts content until you know why
• 03:52 code needs to go into these other individual classes, stay away from them.
• 03:56 All you're gonna do is cause yourself problems, it's not worth it.
• 04:00 You are goinna be able to write some amazing stuff Using just a regular module.
• 04:04 Once you start pushing into advance layers,
• 04:06 that's when we go into these other pieces.
• 04:08 But that's gonna be outside the scope of what we're gonna do here.
• 04:10 We're gonna focus strictly on module.
• 04:12 I'm gonna show you how we can actually work with and
• 04:13 generate some incredible power, based on what we're working with here.
• 04:17 Okay, so, when you see code, if you're gonna copy paste Module,
• 04:20 that's where we are going first, and if your looking for
• 04:23 the code that you've recorded, its going to be under the modules hive here.
• 04:27 Even if these guys are all collapsed, go into modules and
• 04:30 find the Module that you're actually looking for.

Lesson notes are only available for subscribers.