A newbie question re: Forms - Input and Output from an Excel Worksheet

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: NewRipper (whats_at_mail.com)
Date: 04/19/04 

Date: 19 Apr 2004 13:54:46 -0700

I need to use a simple form to input data. The data input goes on to
do some calculations.I would like the resulting calculations to appear
on the form.

For example:

Data input in Form: Cost of Handset: $300, Margin: 50%, Lease period:
3 years.

Calculations ( either in form or in worksheet):
1.Selling Price = Cost *(1+margin)
2.Lease Cost = PMT(7%,Lease Period*12,-Selling Price)

Information required as output on Form: Lease Cost

I did try a couple of books like the Walkenbach one but could not find
how to send the information back from the wroksheet to the form.

Also, how do I disable users form scrolling off the on-screen form.
Windows Freeze pane does not seem to work across computers. Moreover,
that is not covered by Protect Sheet or Protect Workbook.

Could some one please help me or point me to a link where I can find
the relevant information.

Thanks in advance,

Relevant Pages

  • Re: speed up calculation suggestions
    ... We use Fortran for some or our calculations and are being hampered ... Get an updated compiler ... Do you need to process all of the input data? ...
    (comp.lang.fortran)
  • Re: fork():Passing complex data structures between parent and child
    ... To speed up calculations on a multiprocessor ... I would like to pass on input data to child processes and ...
    (comp.os.linux.development.apps)
  • Re: First SysRPL library crashing
    ... Based on the users input, ... opens and collects input data for its calculations. ...
    (comp.sys.hp48)
  • validating input in textbox
    ... input data from the user ... help file in which additional dat is stored, needed for the calculations ... one page i put an excel sheet where the user can input a database of persons ... Private Sub OnlyNumbers() ...
    (microsoft.public.excel.programming)
  • Form and protect sheet
    ... Hi - I have a worksheet and colleagues prefer to input data (including new ... Protection - Protect Sheet), then the option to create a new record or delete an old one is grayed out in the form. ...
    (microsoft.public.excel.misc)