PrompT

[Sonikku`]

What was that command that makes a MsgBox pop up with textbox on the bottom, And how do I refer to the testbox. Thank You.

[seaweed]

You pass the InputBox function the Caption, the Title, and Default text (if you want). The function returns the text that was in the text box when the user pressed Ok. The return value will be an empty string if they pressed Cancel.

Here's a quick example:

Private Sub Form_Load()
    Dim strReturnValue As String
    
    strReturnValue = InputBox("Please enter your name below:", _
        "Enter Your Name", "<type your name here>")
    
    If strReturnValue = "" Then
        MsgBox "You hit cancel, or you didn't type a name!"
    Else
        MsgBox "Well hello, " & strReturnValue & ", nice to meet you."
    End If
End Sub