Results 1 to 3 of 3

macro to increase a cell’s value based on a reference

Threaded View

wiggles8831 macro to increase a cell’s... 06-28-2011, 03:26 PM
tigeravatar Re: macro to increase a... 06-28-2011, 03:37 PM
wiggles8831 Re: macro to increase a... 06-28-2011, 03:50 PM
  1. #1
    Registered User
    Join Date
    06-28-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    macro to increase a cell’s value based on a reference

    I am making an Excel-based set of flash cards (attached). I need to make a macro to increase a cell’s value by 1 based on a reference, and a second macro to decrease it by 1.

    The first sheet (List) has a list of words in German (column B) and the English translation (column C). Column A assigns a number value to each word, which is referenced by the sheet “Flashcards”. Column D is the “Score” for each word.

    On the second sheet (Flashcards) cell C7 takes a random number from List.A:A which cell E7 uses to pull that number’s word in English or German.

    On that same sheet, I have two command buttons. I would like a macro to add 1 to that word’s score (first sheet, column D) if you click “Correct”. The second macro would deduct 1 upon clicking “Incorrect”

    (Note: this is a growing list so it needs to be able reference the entire column)

    I’m a noobie to both VBA and this site so any help is much appreciated!
    Attached Files Attached Files
    Last edited by wiggles8831; 06-28-2011 at 03:52 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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