PC Review


Reply
Thread Tools Rate Thread

Continual addition to Cell

 
 
Euan Ritchie
Guest
Posts: n/a
 
      16th Oct 2008
I'm trying to make up a macro so that everytime i click "A" button a given
cell will count and display how many times the button has been pressed.
Thanks for any help in advance
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      16th Oct 2008
After creating the button, assign this macro to it:

Sub qwerty()
With Range("B9")
.Value = .Value + 1
End With
End Sub

Adjust the cell to suit your needs
--
Gary''s Student - gsnu200807
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
cell addition =?Utf-8?B?RGF2ZSBidWNrdXMgNTI2?= Microsoft Excel Worksheet Functions 2 24th Jul 2006 09:11 PM
Addition to Turn cell red if today is greater or equal to date in cell Rich Microsoft Excel New Users 2 9th Dec 2004 02:06 AM
how do i set up a single cell continual entry in excel to total f. =?Utf-8?B?bWlrZUBzd2FsbG93?= Microsoft Excel Misc 1 7th Dec 2004 12:29 PM
cell addition Chance Microsoft Excel Misc 1 31st Aug 2004 04:07 PM
Same cell addition Richard Microsoft Excel Misc 2 4th Sep 2003 11:46 PM


Features
 

Advertising
 

Newsgroups
 


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