Changing a variable with a SLIDE-BAR.
 

I saw something interresting in a spreadsheet of somebody. The spreadsheet
contained a table with a certain value in for instance cell D5.
The contents of cell D5 was used somewhere in the sheet to perform several
calculations.
To create different situations one would change the value in cell D5.
Underneath cell D5 I saw a slide-bar. Putting the mouse over this slidebar
a Hand appeared (like a Macro was assigned to it).
With the Hand I could move the slide left and right and the value in D5
would change with the position of the slide.
The creator of this sheet is not known by the person who used it.

I would like to use this feature in some of my own sheets.
How can I create something like this?

Ricky

Changing a variable with a SLIDE-BAR.
 

Hi Ricky,

I saw something interresting in a spreadsheet of somebody. The spreadsheet
contained a table with a certain value in for instance cell D5.
The contents of cell D5 was used somewhere in the sheet to perform several
calculations.
To create different situations one would change the value in cell D5.
Underneath cell D5 I saw a slide-bar. Putting the mouse over this slidebar
a Hand appeared (like a Macro was assigned to it).
With the Hand I could move the slide left and right and the value in D5
would change with the position of the slide.
The creator of this sheet is not known by the person who used it.

You can use a form for that.
In menu "View" - "Toolbars"
click on "Forms".
Now select the slidbar.
Within the properties you can select a belonging cell.

Voila your slidebar will change the value in the selected cell.
Within properties you can choose a min and max value and so on.

Greets, Richard.

Changing a variable with a SLIDE-BAR.
 

Richard,

It works perfect and SOO easy.
I thought it was going to be something very complicated.
There are still a lot of things in Excel I do not know.
Thanks very much for your fast response.

Regards, Ricky


"Richard Mücke" wrote in message
...
Hi Ricky,

I saw something interresting in a spreadsheet of somebody. The
spreadsheet
contained a table with a certain value in for instance cell D5.
The contents of cell D5 was used somewhere in the sheet to perform
several
calculations.
To create different situations one would change the value in cell D5.
Underneath cell D5 I saw a slide-bar. Putting the mouse over this
slidebar
a Hand appeared (like a Macro was assigned to it).
With the Hand I could move the slide left and right and the value in D5
would change with the position of the slide.
The creator of this sheet is not known by the person who used it.

You can use a form for that.
In menu "View" - "Toolbars"
click on "Forms".
Now select the slidbar.
Within the properties you can select a belonging cell.

Voila your slidebar will change the value in the selected cell.
Within properties you can choose a min and max value and so on.

Greets, Richard.