Launch Visual Basic 6 or Visual Basic Express. Open the project file in which you want to create a module and command button that creates an Excel spreadsheet from selected data.

Learn how to create a calendar in Microsoft Excel with data using a pre-designed template, Visual Basic code, or a manual method.

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.

Learn how to control Excel worksheets with spin buttons, scrollbars, option buttons, and checkboxes.

How to Create a Graph in Excel & Make It Relative in Size. Microsoft Excel 2010 features a tool set that offers you the option of performing assorted functions on your data, including turning that ...

Creating Running Totals in Excel Is Easier Than You Think A regular Excel range with Month in column A, Profit in column B, and Running Total (currently unpopulated) in column C.

I have an Excel workbook with dozens of custom-named worksheets. Is it possible to create a list of those worksheet names in Excel without having to retype them? A. Yes, you can create a list of your ...

Now that I have shown you how to create a button within an Excel spreadsheet, I want to move forward with using that button to launch a PowerShell script. I will show you how in Part 2.

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.

Excel provides over 16 dozen geometric shapes that you can size and manipulate to your specific needs, plus hundreds of special effects.