Macro text input

[Len]

How can I have a macro request a text input to a specific cell?

 

[Gord Dibben]

Len

In simplest terms.....

Sub gronk()
Range("A1").Value = InputBox("enter your text please")
End Sub

Gord Dibben Excel MVP

 

[Peter Atherton]

-----Original Message-----
How can I have a macro request a text input to a specific cell?
.

Len

Use the Input box method

Sub test()
Dim d
d = InputBox("Enter the first Date", "First Day of
Year", "01/01/04")
Range("A1") = d
End Sub

Regards
Peter