non independent inputs on scroll bars

[pooley343]

Hello to you all,

I am trying to do something in Excel but I don't know how to do it and so I need some help!

Basically, I have two inputs on a calculation that I want to use a scroll bar. However, the problem is that they are not independant.

I am doing something with a right angled triangle.

The inputs are angle (self explanatory) and pitch (although for ease of interpretation I will call pitch "adjacent")

I have a constant (which is the length opposite the angle of the triangle) - specified in a cell. This will never change.

So, angle = atan (opposite/adjacent) and adjacent= opposite / tan(angle)

But like I say, I want them both these inputs on scroll bars so that if you change say angle, it automatically changes adjacent and vice-a-versa. Is this possible?

Some help would be greatly appreciated. Thanks.

[6StringJazzer]

You want to define two variables. You want the user to be able to set either one, and have the other one calculated. In Excel you can't have it both ways. A cell has to be either a constant or a formula. Therefore this needs to be solved with VBA.

Before I fully understood your question I noodled around with it, see attached for a start on this. I will take another look at a VBA solution for this.

[6StringJazzer]

Here is the VBA solution, in Excel 2003 format.

[pooley343]

That is great, that is exactly what I needed!

Just need to incorporate it into my code.

Thanks.