Fortunately, Visual Basic for Applications’ InputBox function supports this task, ... It displays a dialog box and waits for the user to enter content and then click a button to continue.