Excel 2003 - Can a spinner do a look up?

[TheNeffness]

Example:

Spinner links to A1
B1 links to A1

If you click the spinner up, A1 = 1, So B1=1
If you remove the 1 from A1, B1 becomes 0 naturally

What I would like is for B1 to update when the number gets bigger, and not update when the number in A1 returns to 0.

Spinner + 1: A1=1 - B1=1
Spinner - 1: A1=0 - B1=1
Spinner + 1: A1=1 - B1=2

How would someone accomplish this type of goal?

If I can't do that, is it possible for a spinner to update a range of cells based on a lookup?

[Marcol]

See if this helps

Link the Spinner to A1
Then assign this macro to the spinner

Please Login or Register  to view this content.

Is this what you are after?

[TheNeffness]

Thank you very much, you rock my world.