If you want to get any information from the user you can use the InputBox-function. This function displays a dialogbox that lets the user fill inn anything and returns the content as a string.

Sometimes you want to decide what the user is supposed to fill in, instead of accepting any information. That's when you use the InputBox-method :

Sub DecideUserInput()
Dim bText As String, bNumber As Integer
    ' here is the InputBox-function :
    bText = InputBox("Insert in a text", "This accepts any input")
    ' here is the InputBox-method :
    bNumber = Application.InputBox("Insert a number", "This accepts numbers only", , , , , , 1)
    MsgBox "You have inserted :" & Chr(13) & _
        bText & Chr(13) & bNumber, , "Result from InputBox"
End Sub