InputBox

InputBox asks the user to type a value and returns it as text. Application.InputBox is the typed version that can return ranges and numbers.

Code

name = InputBox("Enter the region")

• Ask for text

  name = InputBox("Enter the region") → The typed text, or "" if cancelled

  Simple prompt.

• With a default

  n = InputBox("How many rows?", "Setup", 10) → With a title and default

  Defaults help.

• Detect Cancel

  If StrPtr(answer) = 0 Then Exit Sub → Distinguishes Cancel from an empty entry

  The Cancel test.

• Validate with IsNumeric before using the answer as a number.
• Application.InputBox with Type:=1 forces a number and Type:=8 a range.
• Loop until the answer is valid.

• Cancel returns an empty string, indistinguishable from typing nothing without the StrPtr trick.
• The result is always text from plain InputBox.