Using InputBox Method in Excel VBA

 You can recieve a simple information from user using Message Box in your Excel VBA code: Yes / No / Cancel etc.

But to gather more specific information (formula, number, text, logical value or cell reference) from a user you need Application.InputBox method:

InputBox(Prompt[,Title][,Default][,x][,y][,HelpFile][,HelpContextId][,Type])

where Type specifies the return data type:

Type Values

0

Formula

1

Number

2

Text (String)

4

Logical value (True or False)

8

Cell reference (Range object)

16

Error value

64

Array of values

 

Example: Using InputBox method in Excel

Sub TestInputBox()

    Dim myRange As Range

 

    Set myRange = Application.InputBox(Prompt:= _

        "Please Select a Range", _

        Title:="InputBox Method", Type:=8)

 

    If myRange Is Nothing Then

        ' Range is blank

    Else

        myRange.Select

    End If

End Sub