Shulou(Shulou.com)06/02 Report--

The editor will share with you how to use the inputbox function. I hope you will get something after reading this article. Let's discuss it together.

The type of value returned by the inputbox function is string. The InputBox function displays a prompt in a dialog box, waits for the user to enter the body or press the button, and returns the String containing the contents of the text box. So its return type is a string type.

InputBox is a function in Visual Basic and VBS that pops up a dialog box that displays a prompt, waits for the user to enter the text and presses the button, and then returns the text entered by the user.

Function:

Displays an input box and prompts the user to enter text, number, or select a range of cells in the text box, and returns a string containing the contents of the text box when the OK button is pressed.

Grammar

InputBox (Prompt [, Title] [, Default] [, Xpos] [, Ypos] [, Helpfile,Context])

Parameter description:

(1) Prompt, a required parameter, as a string that appears as a prompt in the input box, its maximum length is about 1024 characters, which is determined by the width of the characters used. If the Prompt contains multiple lines, the lines can be separated by a carriage return character (Chr (13)), a newline character (Chr (10)), or a combination of carriage return newline characters (Chr (13) & Chr (10)).

(2) Title, an optional parameter, is used as a string in the title bar of the input box. If this parameter is omitted, the application name is displayed in the title bar.

(3) Default, an optional parameter, as the default string in the input box, and as the default value when there is no other input. If this parameter is omitted, the text box is empty.

(4) Xpos, optional parameter, numerical value, appears in pairs, specifies the horizontal distance between the left side of the input box and the left side of the screen. If this parameter is omitted, the input box is centered horizontally.

(5) Ypos, optional parameter, numerical value, appears in pairs, specify the distance between the top of the input box and the top of the screen. If this parameter is omitted, the input box is about 1/3 from the lower edge in the vertical direction of the screen.

(6) Helpfile, an optional parameter, is a string that represents a help file, which is used to provide context-sensitive help for the input box. If there is a Helpfile, then there must be a Context.

(7) Context, optional parameter, is a numeric value, the context number of a help topic in the help file. If there is a Context, then there must be a Helpfile.

Related instructions

(1) if both Helpfile and Context parameters are provided, you can press F1 to view the help topic corresponding to Context. Excel will usually automatically add a help button in the input box.

(2) if you click OK (OK) or press enter, the InputBox function returns the contents of the text box; if you click cancel (Cancel), this function returns a zero-length string (").

(3) if you want to enter multiple parameters and omit some of the parameters in the middle, you must add a comma delimiter at the appropriate location.

(4) the InputBox function returns a string. If you need to get a numeric value, you need to use the Val function to convert the string to a value.

After reading this article, I believe you have some understanding of "how to use inputbox function". If you want to know more about it, you are welcome to follow the industry information channel. Thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.