{"id":39,"date":"2018-10-29T21:38:05","date_gmt":"2018-10-29T21:38:05","guid":{"rendered":"http:\/\/www.vbastring.com\/blog\/?p=39"},"modified":"2018-10-29T22:56:35","modified_gmt":"2018-10-29T22:56:35","slug":"excel-vba-tutorial-pt2","status":"publish","type":"post","link":"https:\/\/vbastring.com\/blog\/2018\/10\/29\/excel-vba-tutorial-pt2\/","title":{"rendered":"Excel VBA Tutorial 2"},"content":{"rendered":"

In Excel the steps needed to perform a series of actions can be recorded as a macro. In the previous lesson we looked at the before and after shots of the macro window. <\/p>\n

Here is an image of the Standard VBA Toolbar, which you will see in all editors of VBA<\/strong><\/p>\n

\"standard_vba_toolbar\"<\/a><\/p>\n

It is beneficial to look at the code in the module that is generated from the macro recorder in order to see what syntax Excel VBA expects when you manually code, write instructions, for similar steps. <\/p>\n

As we saw before, macros are stored in modules. A complete module may contain several sub procedures, each one performing a particular action. An advantage of coding your procedures manually is that you can organize them in a suitable arrangement. <\/p>\n

A procedure can be either a function, property, or sub procedure. <\/p>\n

A sub procedure follows the following structure: <\/p>\n

Sub SubProcedureName(arg1,arg2,etc)\r\n\tstatement1\r\n\tstatement2\r\nEnd Sub<\/pre>\n\n\n\n\n\n\n\n
\n\t\t\t\t\t\tPart<\/strong>\n\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\tDescription<\/strong>\n\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\tSub\n\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\tThis is the keyword that every sub procedure begins with.\n\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\tSubProcedureName\n\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\tThis is the name you give to the sub procedure, and the name that appears
\n\t\t\t\t\t\tin the Macro dialog box.  It would benefit you to be meaningful with this name.\n\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\tArguments\n\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\tAdditional instructions you are passing to the sub procedure.  You receive these from the
\n\t\t\t\t\t\tvariable values passed inside the parentheses<\/strong>.  A sub procedure always includes open and close parentheses
\n\t\t\t\t\t\teven though it may not have any arguments.\n\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\tStatements\n\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\tInstructions, commands, you record or write.\n\t\t\t\t\t<\/td>\n<\/tr>\n
\n\t\t\t\t\t\tEnd Sub\n\t\t\t\t\t<\/td>\n\n\t\t\t\t\t\tEvery sub procedure ends with these keywords.\n\t\t\t\t\t<\/td>\n<\/tr>\n<\/table>\n
\t\t\t-Normally comments, or documentation, you add to the code are colored green, and begin with an apostrophe.  It is
\n\t\t\t to your benefit to comment your code so you or someone else understands at a later time why you did what you did.<\/p>\n
\t\t\t-Identions in your code is good practice and causes it to be more readable. <\/p>\n
\t\t\t-Excel VBA automatically capitalizes keywords it recognizes.  This is really helpful in order for you to see if you
\n\t\t\tspelled the word correctly or not.<\/p>\n
\t\t\tOnce you create a sub procedure, it will show up in your macro window (press Alt + F8) to show.  Then select your macro’s name and click “Options” to assign a keyboard shortcut to the macro.<\/p>\n
\t\t\tThe video covers:<\/p>\n
\t\t\t-Code Display 
\n\t\t\t-Procedure Structure 
\n\t\t\t-Sub Procedure Information  
\n\t\t\t-Editting And Calling Subs <\/p>\n
\t\t\t