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.
JLGWhiz - 24 Sep 2006 04:43 GMT
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").
> 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.
Bob Phillips - 24 Sep 2006 10:04 GMT
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.

Signature
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
> 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.