I want to make a macro. I have 8 variables (x1 to x8) that I want to be able to add up to a constant value by changing one or even more then one but not the others.
E.g. (x1*1.1)+ (x2*1.2)+ (x3*1.3)+ (x4*1.4)+ (x5*1.5)+ (x6*1.6)+ (x7*1.7)+ (x8*1.=120
I have the Variable (x1 to x8) listed in Column A and the multipliers (1.1 to 1. in Column B.
How can I change x1 have the other change appropriately? Or change a few variables and have the others change appropriately?
Each variable has a lower limit that they cannot go under and an upper limit that cannot go over. For example, x5 has to be between 5 and 40.
Also, each variable cannot be a negative number.
Is there I way I can do this?
FANTASY REQUEST:
One more request, although this certainly isn’t necessary. Is there anyway to add a scroll-bar to each variable, whereby if I move one scroll-bar, the others move accordingly? Just curious to see if it could be done. (A scroll-bar from the forms tool-box where you can link a cell to it and move the “scroller” or click the arrows on the scroll-bar to change the value in the cell in specified increments and with a lower and upper limit is what I mean.)
Note: That smiley face is 8 )
This message was edited by Cosmos75 on 2002-03-15 15:48
E.g. (x1*1.1)+ (x2*1.2)+ (x3*1.3)+ (x4*1.4)+ (x5*1.5)+ (x6*1.6)+ (x7*1.7)+ (x8*1.=120
I have the Variable (x1 to x8) listed in Column A and the multipliers (1.1 to 1. in Column B.
How can I change x1 have the other change appropriately? Or change a few variables and have the others change appropriately?
Each variable has a lower limit that they cannot go under and an upper limit that cannot go over. For example, x5 has to be between 5 and 40.
Also, each variable cannot be a negative number.
Is there I way I can do this?
FANTASY REQUEST:
One more request, although this certainly isn’t necessary. Is there anyway to add a scroll-bar to each variable, whereby if I move one scroll-bar, the others move accordingly? Just curious to see if it could be done. (A scroll-bar from the forms tool-box where you can link a cell to it and move the “scroller” or click the arrows on the scroll-bar to change the value in the cell in specified increments and with a lower and upper limit is what I mean.)
Note: That smiley face is 8 )
This message was edited by Cosmos75 on 2002-03-15 15:48