[beethoven]

I am a brand new VBA user (ie copied some code off the internet a week ago and am experimenting, so keep it simple please) and I was wondering how to save responses. I have a dialog box that asks your name upon opening the document, and I'd like for that response to be placed in, say, A1. What code would I need? I currently have:

Private Sub CommandButton1_Click()
Dim Response As String
Response = InputBox("What is your name?")
Response = "Your name is " & Response
MsgBox Response
End Sub

If you could help that would be great.

Two days later:
I figured it out by chance after running into other sites online. I will paste my new code should anybody else be helped by it later. Thanks.

Private Sub CommandButton1_Click()
Dim Response As String
Response = InputBox("What is your name?")
Range("A1") = Response
Response = InputBox("Where do you live?")
Range("A2") = Response
Response = InputBox("Please enter your birthdate (MM-DD-YYYY).")
Range("A3") = Response

End Sub

Edited by beethoven, 07 February 2007 - 02:10 PM.

[Advertisements]

beethoven,

try this

*************************************
Response = InputBox("What is your name?")
Range("A1").Value = Response

Response = InputBox("Where do you live?")
Range("B1").Value = Response

Response = InputBox("Please enter your birthdate (MM-DD-YYYY).")
Range("C1").Value = Response
*************************************

good luck
dsm

[dsm]

beethoven,

try this

*************************************
Response = InputBox("What is your name?")
Range("A1").Value = Response

Response = InputBox("Where do you live?")
Range("B1").Value = Response

Response = InputBox("Please enter your birthdate (MM-DD-YYYY).")
Range("C1").Value = Response
*************************************

good luck
dsm

[beethoven]

I'm brand new with this so bear with me. What I pasted (final version) works, and it appears yours is about the same thing. What is the difference or how is yours better?

[dsm]

beethoven,
I misread your original post and assumed the code you pasted did NOT work.
I actually didn't expect your code to work but only because I have always used the more complete syntax.
I just pasted your code and it worked.

Each method is different rather than better.


regards
dsm