Microsoft Office Tutorials and References
In Depth Information
16.1.9.2 InputBox method
The CellFormat object has a number of format-related properties. These are listed here. (The
CellFormat object has a single method named Clear, which clears all formatting.) These are used
just as we used the Font property in the previous code.
AddIndent
Borders
Font
FormulaHidden
HorizontalAlignment
IndentLevel
Interior
Locked
MergeCells
NumberFormat
NumberFormatLocal
Orientation
ShrinkToFit
VerticalAlignment
WrapText
16.1.9.2 InputBox method
We have already discussed the VBA InputBox function, which is used to return input from the
user. The InputBox method of the Application object also returns user information, but has the
advantage of being able to validate the return type and to return Excel formulas, objects, and error
values.
The syntax for the InputBox method is:
Application.InputBox( Prompt , Title , Default , _
Left , Top , HelpFile , HelpContextId , Type )
The parameters are as follows (note that all of the parameters are optional except the Prompt
parameter):
Prompt
The message to be displayed in the dialog box; it can be a string, number, date, or
Boolean value.
Title
The caption for the dialog box. The default caption is Input.
Default
The value that will appear in the text box when the dialog box is displayed. If this
argument is omitted, the text box will be empty.
Left and Top
The upper-left corner of the dialog box in points, measured from the upper-left corner of
the screen.
HelpFile and HelpContextID
Search JabSto ::




Custom Search