Anyone know where I can see code for the Slope funtion written in VB?
I suppose I could write one but why reinvent the wheel.
I actually don't need it for two arrays necessarily. The Y data will just be ascending dates
so I figure i can just use a count of the data in the X array. I would think that would be valid?
Have you ever wanted to restrict the users input in a textbox to numbers, and while doing that make sure that they can't 'cheat' by pasting in non-numeric text? Of course you can do that with code you write yourself but it's tedious and error-prone …
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…