MS Excel Champions

C

CombatWombat

Veteran XV
Not the TW meber. The program.

I have a bunch of sliders which I want to behave like the tax sliders in Civ. So their total value cannot be greater than 100. Sliding one up 10% will cause the other two to slide down 5% each.

So far I have failed by getting sucked into some kind of circular dependancy hell.
 
Wow... I never got far integrating VBA Form Controls in Excel spreadsheets.

They always scared me... for that exact reason.
 
Yes. This is the first time I am trying them. But i havnt actually ventured into the VBA part. I just sort of hit the form button and stuck some sliders in and assigned them to different cells.

Of course this doesnt work for what I need to do.
 
kraska said:
just dont move slider b/c.

or use a third slider to control the A - b/c ratio
Click to expand...

What's the point of a slider if you cannot slide it?

Also I may (will) need more than 3 sliders. I'm thinking this isnt really possible to pull off in excel.
 
You must log in or register to reply here.
Back
Top