Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / September 2006

Tip: Looking for answers? Try searching our database.

Using data captured by Inputbox

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jcody - 24 Sep 2006 03:42 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.