View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default 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.