INPUT BOX

[Guest]

I have created an input box who I can fill in a text.
How can I make a macro so that the text of the input box comes in cell A1?
Thanks for help.

 

[Ivan F Moala]

On 2002-03-13 00:36, Anonymous wrote:
I have created an input box who I can fill in a text.
How can I make a macro so that the text of the input box comes in cell A1?
Thanks for help.

Range("A1") = InputBox("Input text to go in A1")


Ivan