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!![]()
Bookmarks