Instead of clicking on multiple buttons to add different Word and Excel formats, record a macro, add it to Quick Access Toolbar & use it to get things done.

An Excel macro is a sequence of commands (or directives) that you record to perform a series of tasks. We'll show you how to create custom macros for your spreadsheet.

VBA sub procedures can perform lots of tasks and there are many ways to execute those functions in Microsoft Excel.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.

In the next section, we’ll add a macro button that calls this procedure to the Quick Access Toolbar (QAT). Don’t add this procedure to the UserForm’s module.