Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
New numbers Larry Excel Worksheet Functions 7 August 31st 06 04:54 PM
How to click on a cell and have the content of the cell display in a different cell [email protected] Excel Worksheet Functions 0 June 6th 06 03:05 PM
Urgent date/scheduling calc needed jct Excel Worksheet Functions 3 February 24th 06 01:36 AM
clicker that advances one number per click in a cell Rayco Excel Discussion (Misc queries) 10 August 23rd 05 04:13 PM
clicker that advances one number per click in a cell Rayco Excel Worksheet Functions 1 August 7th 05 06:58 AM


All times are GMT +1. The time now is 09:33 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"