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.

Like other Excel form elements, check boxes appear on the drawing layer ... Select the text and type to add your own label beside ... double-click the check box to open Microsoft Visual Basic.

And although VBA is installed by default, accessing the Visual Basic Editor (VBE), through which you’ll enter your VBA code, doesn’t automatically appear in the Ribbon. Must-read Windows coverage ...

Fortunately, Visual Basic for Applications’ InputBox function supports this task, so you won’t have to work very hard! You’ll learn how to select a range using InputBox in this article.