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.

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.