Donna,
Right click the control on the worksheet and choose Format
Control, then choose the Control tab. There, choose a minimum and
maximum value, and enter a cell reference in the Cell Link box.
The value of the control will automatically be placed in that
cell.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com