MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Call Linest Function

  Asked By: Lorenzo    Date: Dec 24    Category: MS Office    Views: 1833

I would like to call Linest function by a single button click.

How can I do this?



3 Answers Found

Answer #1    Answered By: Blandina Garcia     Answered On: Dec 24

Your question does not make your need clear. What do you expect the button  to
do? Where in the spreadsheet are the data and where do you want the array
produced by Linest placed? How will the result be different from simply
putting the Linest function  as an array in the target area?

Answer #2    Answered By: Addison Campbell     Answered On: Dec 24

Here listed what I want to do with the Linest Function:

1. I will request user to enter values for X1, X2, X3, .......and Y
2. User only need to click  on one button, let say "Linest Function", the result
will be calculated and display on the worksheet.
3. I want to have the form with button  because my user do not know how to use
the linest function.

Answer #3    Answered By: Aaleyah Khan     Answered On: Dec 24

If you create a data area on the spreadsheet and an area where the lines
function displays its results the user would just have to put the x values and
the y values in the data area and the results of the linest function  would
display automatically. The user would not need to understand how to set up
the function as you would already have done that on the worksheet. This is
the simple straightforward way of doing it.

If you want to make it more complicated you will create a userform with two
textboxes for the x and y inputs, an enter button  which transfers the pair of
values to the spreadsheet and a calculate button which would close the
userform. The linest function would still be in the spreadsheet (put there by
you) not generated when the spreadsheet is in use. Then you would have a
button to open the userform. I do not think this is a sensible way to do it.

Didn't find what you were looking for? Find more on Call Linest Function Or get search suggestion and latest updates.