Using data captured by Inputbox

[Guest]

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.

 

[Guest]

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").

 

[Bob Phillips]

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)