Such buttons often run macros that you write using Visual Basic. When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window.

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.

How to Create a Form Using Microsoft Excel 2007. There are several ways to add forms in Microsoft Excel 2007, without the need to learn Visual Basic and type complex code.

Microsoft recently made some significant enhancements to its Visio add-in for Excel, enabling users to create Visio diagrams from within Excel. Here's how it works.