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