_Application.InputBox Method

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Displays a dialog box for user input. Returns the information entered in the dialog box.

public object InputBox (string Prompt, object Title, object Default, object Left, object Top, object HelpFile, object HelpContextID, object Type);

Public Function InputBox (Prompt As String, Optional Title As Object, Optional Default As Object, Optional Left As Object, Optional Top As Object, Optional HelpFile As Object, Optional HelpContextID As Object, Optional Type As Object) As Object

Parameters

Prompt: String

Required Object. The message to be displayed in the dialog box. This can be a string, a number, a date, or a Boolean value.

Title: Object

Optional Object. The title for the input box. If this argument is omitted, the default title is "Input."

Default: Object

Optional Object. Specifies a value that will appear in the text box when the dialog box is initially displayed. If this argument is omitted, the text box is left empty. This value can be a Range object.

Left: Object

Optional Object. Specifies an x position for the dialog box in relation to the upper-left corner of the screen in points.

Top: Object

Optional Object. Specifies a y position for the dialog box in relation to the upper-left corner of the screen in points.

HelpFile: Object

Optional Object. The name of the Help file for this input box. If the HelpFile and HelpContextID arguments are present, a Help button will appear in the dialog box.

HelpContextID: Object

Optional Object. The context ID number of the Help topic in HelpFile.

Type: Object

Optional Object. Specifies the return data type. If this argument is omitted, the dialog box returns text. Can be one or a sum of the following values.You can use the sum of the allowable values for Type. For example, for an input box that can accept both text and numbers, set Type to 1 + 2.

Returns

Object

Remarks

Use InputBox to display a simple dialog box so that you can enter information to be used in a macro. The dialog box has an OK button and a Cancel button. If you choose the OK button, InputBox returns the value entered in the dialog box. If you click the Cancel button, InputBox returns False.

If Type is 0, InputBox returns the formula in the form of text — for example, "=2*PI()/360". If there are any references in the formula, they are returned as A1-style references. (Use ConvertFormula(Object, XlReferenceStyle, Object, Object, Object) to convert between reference styles.)

If Type is 8, InputBox returns a Range object.

If you use the InputBox method to ask the user for a formula, you must use the FormulaLocal property to assign the formula to a Range object. The input formula will be in the user's language.

The InputBox method differs from the InputBox function in that it allows selective validation of the user's input, and it can be used with Microsoft Excel objects, error values, and formulas. InputBox with no object qualifier calls the InputBox function.

Applies to