VBA Inputbox
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...
That's all, I hope it helped! If not, feel free to email me at erik [at] vbahowto [dot] com
|
Are you struggling to learn VBA?
If your answer to the above question is yes, then I strongly recommend that you check out these VBA Crash Course videos |
