Hello,

Anyone know how to change the window size of the Application.inputbox
object? I am currently limited to 5 lines of text inside the box with
each line being approximately 45 characters wide (depending on the
characters).

I am using office XP. In the past, with 97 and 2000 for example, these
boxes automatically resized to accomodate all text. However, my text
is trimmed after 5 lines.

Can the size of this window be changed?

Thanks for your help....

ndp


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

You're going to need to use a Userform.

"ndp" wrote in message
...

Hello,

Anyone know how to change the window size of the Application.inputbox
object? I am currently limited to 5 lines of text inside the box with
each line being approximately 45 characters wide (depending on the
characters).

I am using office XP. In the past, with 97 and 2000 for example, these
boxes automatically resized to accomodate all text. However, my text
is trimmed after 5 lines.

Can the size of this window be changed?

Thanks for your help....

ndp


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements

Ok, I can give that a try. I've never used a form for gathering data.
I would need to take the user's inputs from the form (option buttons)
assign them to variables, and plug them into another sheet. Pluggin
the information into another sheet isn't a problem. However, I'm no
quite sure how to assign the variables based on which option button
might be selected. I see that I can edit the code of each individua
option button...

Excel's help pages on this subject are somewhat limited. Anyone hav
some sample code I can look at and learn???

Thanks again..

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

http://www.microsoft.com/ExcelDev/Articles/sxs11pt1.htm
Lesson 11: Creating a Custom Form
Excerpted from Microsoft® Excel 97 Visual Basic® Step by Step.

http://support.microsoft.com/default.aspx?kbid=161514
XL97: How to Use a UserForm for Entering Data

http://support.microsoft.com/default.aspx?kbid=213749
XL2000: How to Use a UserForm for Entering Data

http://support.microsoft.com/?id=168067
File Title: Microsoft(R) Visual Basic(R) for Applications Examples for
Controlling UserForms in Microsoft Excel 97
File Name: WE1163.EXE
File Size: 161742 bytes
File Date: 05/08/97
Keywords: kbfile
Description: This Application Note is an introduction to manipulating
UserForms in Microsoft Excel 97. It includes examples and Microsoft Visual
Basic for Applications macros that show you how to take advantage of the
capabilities of UserForms and use each of the ActiveX controls that are
available for UserForms

Peter Aiken Articles:
Part I
http://msdn.microsoft.com/library/en...FormsPartI.asp
Part II
http://msdn.microsoft.com/library/en...ormsPartII.asp

--
Regards,
Tom Ogilvy

"ndp" wrote in message
...

Ok, I can give that a try. I've never used a form for gathering data.
I would need to take the user's inputs from the form (option buttons),
assign them to variables, and plug them into another sheet. Plugging
the information into another sheet isn't a problem. However, I'm not
quite sure how to assign the variables based on which option buttons
might be selected. I see that I can edit the code of each individual
option button...

Excel's help pages on this subject are somewhat limited. Anyone have
some sample code I can look at and learn???

Thanks again...


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements