BJ,

ry linking the spinner to a cell with the formula

=IF(A1=0,C1,C2)

HTH,
Bernie
MS Excel MVP

"BJ" wrote in message
...
I searched through the forum but I can't find the solution I'm looking
for. I want the Cell Link in a single Spinner control to depend on the
value of another cell. In other words, if A1=0, then the Spinner
control will index C1, and if A1=1 then the Spinner control will index
cell C2. Is this possible?

Thanks