• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA coefficient trendline

Hello.
I would like to be able to control the range inside the coefficient trendline from an input box, I don't figure out how.

EXP(INDEX(LINEST(LN(B3:B21),LN($A$3:$A$21),,),1,2))

the range B3:B21 and the range A3:A21 how is possible from an input box change for any range I want, a little sniped code as example would be nice.
Thank you for reading this post.
Have a nice weekend.
 

Marc L

Excel Ninja
Hi !​
Use the Application.InputBox method with its Type parameter set to 8 like the sample within the VBA inner help …​
 
Sorry, Sorry, Sorry, I don't come here to much so, I am clicking and clicking everywhere, I don't got any clue where is possible to find the example sorry this is not familiar site for me.
 
Top