What is InputBox? VBA’s InputBox function is one of the most helpful functions you’ll use. It displays a dialog box and waits for the user to enter content and then click a button to continue.

Automatically Size a Text Box with User Input The following example demonstrates the effects of the AutoSize property with a single-line TextBox and a multiline TextBox.