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.

Here is where the magic of VBA (Virtual Basic for Applications) comes in. It's an undiscovered Excel feature for creating custom functions, which has entirely changed how I handle my spreadsheets.

Visual Basic for Applications (VBA) gives you an additional option for embedding images in Excel. When you add an image through the VBA window, you can embed it into an Excel dialog box.

Learn how to enable or disable Trust access to Visual Basic Project in Word, Excel, PowerPoint. Turn it on or off using REGEDIT, GPEDIT, and in-built settings.

You can create and set the trigger for an alarm in MS Excel by creating a VBA module. Learn how to Ring an Alarm in Microsoft Excel.

Microsoft's Excel team takes to Reddit to answer questions and reassure users that yes, you can open up more than one Excel window at the same time.