Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Forms: The basics please
Hi, Would some kind soul help me get going with Excel forms. I have a spreadsheet with some complex mathematical formula on it that computes various parameters for the space industry. The user types in two or more variables into certain cells, and the results of the computation appear the highlighted and labelled cells. What I want to do is to clean all this up by presenting users with a data-entry form. They type in the variables they want, press the Compute button, and the answer appears in a Result box. To get me going I would like to start at the beginning. Imagine cell A1 is the first variable (numeric), and B1 the second variable (numeric). C1 is simply the product of A1 and B1. The form would have three boxes on it, one to enter the first variable, the second box to enter the second variable, a dimmed third box for the result, and a Compute button, which when pressed would undim the third box and show the product of the two numbers entered. Eventually I would like to send the form to others in the company as an Add-In. All suggestions gratefully received. Regards Jenny -- Wibs ------------------------------------------------------------------------ Wibs's Profile: http://www.excelforum.com/member.php...o&userid=28922 View this thread: http://www.excelforum.com/showthread...hreadid=522135 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Electronic Evaluation/Feedback Forms in Excel | Excel Discussion (Misc queries) | |||
Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Excel Basics | Excel Discussion (Misc queries) | |||
protection on excel forms | Excel Worksheet Functions |