![]() Once the series of activities/steps are recorded, the Macro is essentially created into a module in VBA and we can go in to review/edit the codes. It is important to note that Macro is really part of VBA. We can create user forms, automate a series of steps, create reports, send emails out and a lot more. Except, instead of recording the series of steps, we have to write them as lines of codes in modules. VBA (Visual Basic for Application) is very similar. Excel records that series of activities/processes so that with a click of a button, Excel will repeat those specific steps for us. ![]() Macro is a recording tool in Excel – we press a button to “start recording”, we then do a series of activities/processes and at the end we press a button to “end recording”. ![]() Before we start, let’s talk about what Macro and VBA are about. To enable Macro/Visual Basic for Application (VBA) in Excel, there are two steps. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |