• 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


  • 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

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


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.