Using data captured by Inputbox
 

How do you extract and use the data capture by Inputbox functionality? I'm
developing which solicits data via questions. I am trying to use the data
captured to populate worksheets within the file.

Using data captured by Inputbox
 

There are two types of InputBox techniques. The Method and the Function. I
suggest that you use the help facility to read about each type. To answer
your specific question:

Suppose you use the sytax:
Sub InptBx()
Response = InputBox("Enter your
name.", "Name")
ActiveSheet.Range("A1") = Response
End Sub
"Response" will return whatever is entered by the user into the input box.
The nest line of code puts that data into Range("A1").


"jcody" wrote:

How do you extract and use the data capture by Inputbox functionality? I'm
developing which solicits data via questions. I am trying to use the data
captured to populate worksheets within the file.

Using data captured by Inputbox
 

have you considered using a userform? It may be better if you have multiple
questions. Or maybe just list the questions on a spreadsheet and let them
type into (coloured) cells.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"jcody" wrote in message
...
How do you extract and use the data capture by Inputbox functionality?
I'm
developing which solicits data via questions. I am trying to use the data
captured to populate worksheets within the file.