View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default is there a control 2 increase a number in a cell by click on the c

On the control toolbox is a spinner button. Add one of these to your sheet.
Right click the spinner and add the linked cell (A1 for instance) and if you
want you can change the orientation to vertical. There are also parameters
for min and max that you may want to change. After that exit design mode by
clicking the ruler and pencil icon on the control toolboax and you are up and
running...
--
HTH...

Jim Thomlinson


"cflads" wrote:

Is there a control to advance a number in a cell by one each time you click
on the cell?