How to use VBA’s InputBox function to select a range on the fly in Excel Your email has been sent Often, you’ll want Excel users to specify a range that the app then uses in an automated way.

The following example demonstrates the effects of the AutoSize property with a single-line TextBox and a multiline TextBox. The user can enter text into either of the TextBox controls and turn ...

Pro tip: Populate an Excel UserForm combo box without VBA Your email has been sent Susan Harkins shows you two easy ways to populate an Excel UserForm, and neither requires a single bit of VBA code.