When the button must appear in a dialog box, create it using Excel's Visual Basic for Applications window. Once you have made the button, you can then code the VBA event that you want it to run.

Learn how to easily set up your own search field in Excel to find and filter content within a table.

How to Create a Check Box in Excel 2007. Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes.

Excel macros are like mini-programs that perform repetitive tasks, saving you a lot of time and typing. Here's everything you need to know to start programming macros yourself.

Learn how to make a flowchart in Microsoft Excel without using any external add-on - but with SmartArt Graphics or Shapes Tool.

Figure 1: Type "flowchart" into the search box. This will cause Excel to display a number of Visio add-ins similar to what you see in Figure 2. [Click on image for larger view.] ...

Before LAMBDA was introduced to Excel, you'd need to know how to use VBA or macros to create your own function. However, today, Excel's LAMBDA tool lets you do this using familiar Excel language ...