Userform

[Chris Berry]

I need a very basic userform with two text boxes for input, a label box
for the result and a button to print the userform. The formula is
simply (first text box + ((1 - Second text box) * First text box).

I want this userform to be the only thing shown when this spreadsheet
is opened and the ability to save the calculation is not important.

How would you go about this?

 

[Guest]

Since you didn't include an address to send the invoice <g>, I am guessing
you want some general direction, tips and techniques:

See this tutorial here
http://www.dicks-blog.com/excel/2004/09/linking_userfor.html

John Walkenbach's site:
http://j-walk.com/ss/excel/tips/tip84.htm

http://j-walk.com/ss/excel/tips/userformtips.htm
Userform Tips

Peter Aiken Articles:

watch word wrap. the URL should all be one line.
Part I
http://msdn.microsoft.com/library/en-us/dnoffpro01/html/IntroductiontoUserFo
rmsPartI.asp
Part II
http://msdn.microsoft.com/library/en-us/dnoffsol02/html/IntroductiontoUserFo
rmsPartII.asp


http://support.microsoft.com/default.aspx?scid=kb;en-us;829070
How to use Visual Basic for Applications examples to control UserForms in
Microsoft Excel

http://support.microsoft.com/?id=168067
XL97: WE1163: "Visual Basic Examples for Controlling UserForms"

Microsoft(R) Visual Basic(R) for Applications Examples for Controlling
UserForms in Microsoft Excel 97

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

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


To do the last part, you will need to use the workbook_Open event to hide
the application and show your userform. Chip Pearson's page on events:

http://www.cpearson.com/excel/events.htm