VBA: Taking text typed into an Input Box and pasting it into a specific cell

C

cparaske

I've been trying to take information typed into an input box and havin
Excel then paste it into a specified cell on a worksheet. Does anyon
know what the code to do this is?

Literally can't get past:
nameses=inputbox("X","X"
 
J

J.E. McGimpsey

one way:

Dim nameses As String
nameses = InputBox("X", "X")
Sheets("Sheet1").Range("A1").Value = nameses
 
Top