ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   is there a control 2 increase a number in a cell by click on the c (https://www.excelbanter.com/excel-discussion-misc-queries/108035-there-control-2-increase-number-cell-click-c.html)

cflads

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

Jim Thomlinson

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?



All times are GMT +1. The time now is 12:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com