Microsoft Excel offers Visual Basic for Application (VBA) as a scripting tool to let you add additional functionality to your Excel spreadsheets. You can use VBA to prompt the user to enter a filename ...

Automating the selection process isn’t difficult if you rely on VBA’s InputBox in Microsoft Excel. Often, you’ll want Excel users to specify a range that the app then uses in an automated way.

Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code. Last month’s article, “Pro tip: Add a UserForm to aid data entry in Excel,” shares ...

Please note: This item is from our archives and was published in 2017. It is provided for historical reference. The content may be out of date and links may no longer function. Q. Is it possible to ...

Using Excel to create business forms means including elements available on your Web-based and paper forms, including check boxes. Like other Excel form elements, check boxes appear on the drawing ...