Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default cell incrementing by a specific number

I Have the number 0 in cell A10 and would like a button to increment
this cell by 1 each time i click on it

Can some one help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default cell incrementing by a specific number

Assign this macro to your button. Change cell address to suit.

Range("A1").Value = Range("A1").Value + 1

HTH
Regards,
Howard

"andrewsheldon98" wrote in
message ...
I Have the number 0 in cell A10 and would like a button to increment
this cell by 1 each time i click on it

Can some one help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,337
Default cell incrementing by a specific number


"andrewsheldon98" wrote in
message ...
I Have the number 0 in cell A10 and would like a button to increment
this cell by 1 each time i click on it

Can some one help.



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/



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
incrementing sheet number iain_greenan Excel Discussion (Misc queries) 4 November 11th 08 04:29 PM
Incrementing a formula by X number Bowbender Excel Worksheet Functions 3 September 21st 05 04:14 PM
Incrementing a worksheet number in a formula [email protected] Excel Worksheet Functions 1 July 15th 05 03:59 AM
Incrementing a worksheet number in a formula [email protected] Excel Worksheet Functions 1 July 15th 05 03:46 AM
Count number of times a specific number is displayed in a cell ran subs Excel Worksheet Functions 1 June 27th 05 05:01 PM


All times are GMT +1. The time now is 05:37 PM.

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

About Us

"It's about Microsoft Excel"