How to assign negative value using Scroll Bar in Worksheet

[Guest]

Excel 2003 SP3
Win XP Pro SP2

I use a scroll bar assigned to a cell in order to vary the value of this cell.
The range of the variable can be given in the "Properties" of the scroll
bar. For positive values this works very fine. As soon as I go towards
negative values, the displayed value in the cell jumps to 65'XXX (2 at the
power of something I suppose). How can I get there negative values? If I
itroduce them manually in the assigned cell using the keyboard, it works fine.
Thanks in advance for your advice.

 

[Jim Rech]

Interesting. It looks like you're going to have to use a formula in another
cell, that refers to the cell linked to the scroll bar. It will update real
time for your calc mode is set to automatic. Perhaps:

=IF(A1>32767,A1-65536,A1)

where A1 is the linked cell.

--
Jim
| Excel 2003 SP3
| Win XP Pro SP2
|
| I use a scroll bar assigned to a cell in order to vary the value of this
cell.
| The range of the variable can be given in the "Properties" of the scroll
| bar. For positive values this works very fine. As soon as I go towards
| negative values, the displayed value in the cell jumps to 65'XXX (2 at
the
| power of something I suppose). How can I get there negative values? If I
| itroduce them manually in the assigned cell using the keyboard, it works
fine.
| Thanks in advance for your advice.
|

 

[Guest]

Nice solution, thank you. It works if you use the cell where
you put the formula only as indicator. But if the user tries to
enter a value "manually" w/o using the scroll bar with the key-
board, the nice formula is overwritten.

Arrigo