How to assign negative value using Scroll Bar in Worksheet

H

Harribo

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.
 
J

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.
|
 
H

Harribo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top