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 / New Users / December 2005

Tip: Looking for answers? Try searching our database.

InputBox

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
magix - 11 Dec 2005 15:30 GMT
Hi,

Normally Inputbox has one editbox, how can have more editbox in one inputbox
?
Please help by giving example.

Regards,
Magix
Earl Kiosterud - 11 Dec 2005 16:30 GMT
Magix,

For this you would create your own UserForm (in the VBE) and write the code
to show it, look at the user input, etc.

Earl Kiosterud
www.smokeylake.com

> Hi,
>
[quoted text clipped - 5 lines]
> Regards,
> Magix
Bob Phillips - 11 Dec 2005 16:31 GMT
You would need to build a custom userform to handle it.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> Hi,
>
[quoted text clipped - 4 lines]
> Regards,
> Magix
David McRitchie - 11 Dec 2005 16:41 GMT
You can't change InputBox to have more than one text input area.
You can use separators and parse the argument into several parts.

You alternatives include
Using an area in the worksheet, or any other worksheet.
Using Forms
   A quick search turned up this one, might be of interest
      J-Walk Enhanced Data Form v2     (addin)
      http://www.j-walk.com/ss/dataform/
      http://www.j-walk.com/ss/dataform/features.htm
   Excel -- Create an Order Form [ http://www.contextures.com/tiptech.html ]
      http://www.contextures.com/xlOrderForm01.html
   Flash presentations  look for "Building Excel Applications"
      http://www.datapigtechnologies.com/ExcelMain.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel    [site changed  Nov. 2001]
My Excel Pages:  http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:        http://www.mvps.org/dmcritchie/excel/search.htm

> Hi,
>
[quoted text clipped - 4 lines]
> Regards,
> Magix
 
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.