Edytuj

Udostępnij za pośrednictwem


_Application.InputBox Method

Definition

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

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