Input box

[Lauren279]

Can anyone help with input boxes, i need, how to assign a cell for the text written in the input box, how to change the input box "title"

 

[VoG]

Try like this

Sub test()
Dim x As String
x = InputBox("Enter a value", "This is my title")
Range("A1").Value = x
End Sub

 

[Lauren279]

Ok thanks, will give it a go

 

[jicbs]

https://www.youtube.com/playlist?list=PLNIs-AWhQzckr8Dgmgb3akx_gFMnpxTN5

Andrew Gould at Wise Owl Tutorials has put together a fantastic series on VBA; "Input Boxes" and "Application Input Boxes", the time spent watching these will be time well spent.

<colgroup><col width="77" style="width: 58pt;"> <tbody> </tbody>