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. 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.
SEE: 83 Excel tips every user should master (TechRepublic)
I’m using Microsoft 365 on a Windows 10 64-bit system, but you can use earlier versions. Excel Online won’t support the VBA procedure in this article. Download the demonstration .xlsm, .xls, and .cls files to easily access the code.
What is InputBox?
VBA’s InputBox function is one of the most helpful functions you’ll use. It displays a dialog box and…