Are Form 944 Pr Fractions 2011-2023

Instructions and Help about Are Form 944 Pr Fractions

Hi my name is Stephanie Krieger and I'm a Microsoft Office MVP in this video I'm going to be demonstrating a few tasks from the article titled using VBA to format long documents in the 2023 office system in a fraction of the time and you can find that article on the MSDN office developer center well most of what I'm going to show you can apply to your work with VBA in many office programs but since this demo is about formatting long documents let's go ahead and jump over to word if you record macros you know that those macros can save you a lot of time on repetitive tasks like formatting the sixty-eight tables that I copied from Excel into the sample report for example but you also know that recorded macros have limits so in this example I would need to run the macro separately for each table right I'd need a different macro for each type of table that requires unique formatting and I'd probably still have to take some actions manually for things that I can't record all right well in this demo we're going to look at a couple of different types of VBA constructs that you can use to save a lot more time than that first we're going to look at a loop which is a type of statement that enables you to loop through multiple instances of an object such as to apply your formatting to all tables in the document at once and next we're going to look at conditional statements and that lets you see how you can execute different actions in the same macro based on conditions you specify like when you need different formatting based on the type of table okay so take a look at...