XLIDE gives Excel VBA projects a modern VS Code workspace. Add one or more .xlsm, .xlsb, or .xlam workbooks to your VS Code project and XLIDE detects them automatically. Navigate each workbook's VBA ...
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.