G Gord Dibben Feb 8, 2004 #2 Len In simplest terms..... Sub gronk() Range("A1").Value = InputBox("enter your text please") End Sub Gord Dibben Excel MVP
Len In simplest terms..... Sub gronk() Range("A1").Value = InputBox("enter your text please") End Sub Gord Dibben Excel MVP
P Peter Atherton Feb 8, 2004 #3 -----Original Message----- How can I have a macro request a text input to a specific cell? . Click to expand... 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
-----Original Message----- How can I have a macro request a text input to a specific cell? . Click to expand... 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
