Jim,

1. Set the min to 0, set the max to 200, set the current value to 100
If your linked cell is A1, in another cell add the formula "=A1-100"
Use the other cell as your "linked" cell.

2. see...
http://support.microsoft.com/default...b;en-us;838910
"Controls move to the left..."

Jim Cone
San Francisco, USA



{James Hawkins} Excel 2003
I add a spinner control to the work sheet
Link it to a cell
SmallChange property is set to 1
Max property is set to 100
Min property is set to -100
When I spin down from 0 to -1, the Value property shows -1 but the linked
cell changes from 0 to 65535. It should change to -1.
Changing the cell format has no effect. How can I fix this?

Second problem:
I add a control to a sheet.
Unless I use a 1 in the Placement property, versus 2 or 3, when I print the
page or preview, all my controls move to the left most side of the sheet. Why
can I not use placement options 2 or 3?