Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform
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? -- Chris Berry ------------------------------------------------------------------------ Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165 View this thread: http://www.excelforum.com/showthread...hreadid=570484 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Userform
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...g_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...uctiontoUserFo rmsPartI.asp Part II http://msdn.microsoft.com/library/en...uctiontoUserFo rmsPartII.asp http://support.microsoft.com/default...b;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 -- Regards, Tom Ogilvy "Chris Berry" wrote: 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? -- Chris Berry ------------------------------------------------------------------------ Chris Berry's Profile: http://www.excelforum.com/member.php...o&userid=36165 View this thread: http://www.excelforum.com/showthread...hreadid=570484 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform to enter values and shown in same userform in list | Excel Programming | |||
Looping procedure calls userform; how to exit loop (via userform button)? | Excel Programming | |||
Activating userform and filling it with data form row where userform is activate | Excel Programming | |||
Access from add_in userform to main template userform.... | Excel Programming | |||
Linking userform to userform in Excel 2003 | Excel Programming |