So, here we see Module1, and you wanna double-click these to see what's in them, as I just did here for Module1. And so, over time, you might wanna consolidate these. If you haven't named them, every time you open this Workbook and create a new macro it will go into a new Module. You can rename the Modules by where the Properties window below. And sometimes you'll see more than one Module.
#DOWNLOAD WAKHRA SWAG BADSHAH MP3 PLUS#
Click the plus if it hasn't been expanded, we will see Modules. So in the current Workbook, it's called WorkbookWithMacros. Click the plus there, we expose aspects of it, including Modules. But, by clicking the pluses just to the left, for example, PERSONAL, that's the personal macro Workbook, more about that in the next two movies.
#DOWNLOAD WAKHRA SWAG BADSHAH MP3 CODE#
Now, that also changed the Code window, but if the view looks like this, it sometimes might throw you. So, off to the left here is a minus, I'm gonna click it. If there are other Workbooks open, you will see those names. Now, any time you go to this window, you do see the current Workbook listed over in the left hand side. The Properties window below is going to be handy occasionally, although not nearly as important as the other two. If the Code window's not visible on the right, you definitely wanna see this, View Code, and also the VBAProject window, it's called Project Explorer, we wanna see that as well, too. If neither of those is present, you wanna go to the View tab and there's where we see Code, that's the first entry. For many people, the two most important windows, and they're nearly always present, are the VBAProject window, typically on the upper left side, and then to the right of it, occupying the bulk of the screen, the code window. Now, this window isn't always what we see right now. It varies widely depending upon the person or what you're trying to do with macros. Now, the more you work with macros, the more you will begin to understand VBA, and in different degrees, perhaps you will be working with it more closely. We're into the world of Visual Basic, or we press Alt + F11, we're back into the Excel environment. Once again, note that keystroke shortcut, Alt + F11, it will come in handy many times as we work with Excel macros. If we didn't know that shortcut, we could go to the Developer tab and the far left button Visual Basic.
If we want to view the VBA code, we can press Alt + F11. In this Workbook, we're looking at, let's say, any worksheet, we happen to be looking currently at CurrentStaff. Program in Visual Basic, or to be more precise, Visual Basic for Applications. Every time you create a macro with a recording process, you are, in effect, writing a program.
0 kommentar(er)
