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