This is a text and video example of a VBA Inputbox:

The value provided to a VBA inputbox can be used in a message box or cell. This is a simple example of a VBA inputbox:

***************************************************************

Public Sub InputBox() 

      Dim strMsg As String
      Dim strInputBoxText As String 

      strInputBoxText = Application.InputBox("Enter Your Name") 

      Range("D11") = strInputBoxText 'Assign the value of the inputbox to a cell. 

End Sub 

****************************************************************

Now watch how it’s done…

Let me know if you have any questions

[simple_contact_form]