+ Reply to Thread
Results 1 to 5 of 5

repeated addition on the same cell

Hybrid View

Suraj3825 repeated addition on the same... 11-28-2012, 10:25 AM
patel45 Re: repeated addition on the... 11-28-2012, 11:11 AM
Suraj3825 Re: repeated addition on the... 11-28-2012, 11:50 AM
watersev Re: repeated addition on the... 11-28-2012, 11:34 AM
Suraj3825 Re: repeated addition on the... 11-28-2012, 11:52 AM
  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    repeated addition on the same cell

    Im creating sporting score sheet wer there are 7 different values of scoring (i.e. 1,2,3,4,5,6&7). i have created 7 buttons in the name of these numbers. i want to create a mocro in a way that all these macros shud be assigned to one cell (say A1) and wenever i click on any button the value of that button shud be added to the existing value in A1.
    if i press button 1, A1 shud show "1"
    and then if i press button 6, A1 shud show "7"
    then if i press button 1 again it shud show "8" and so on
    how do i create a macro like this wer it keeps adding to the same cell??

  2. #2
    Forum Expert
    Join Date
    07-15-2012
    Location
    Leghorn, Italy
    MS-Off Ver
    Excel 2010
    Posts
    3,431

    Re: repeated addition on the same cell

    attach sample file with buttons, I'll add code
    If solved remember to mark Thread as solved

  3. #3
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: repeated addition on the same cell

    i hope file is attached..
    Attached Files Attached Files

  4. #4
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: repeated addition on the same cell

    hi Suraj3825, welcome to Excelforum, option
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-28-2012
    Location
    Karnataka, India
    MS-Off Ver
    Excel 2007
    Posts
    48

    Re: repeated addition on the same cell

    any explaination about wat the concept is called or how it works wud be helpful.
    meanwhile the file works perfectly. thank yu very much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1