+ Reply to Thread
Results 1 to 4 of 4

Excel flashcard spreadsheet.

  1. #1
    Registered User
    Join Date
    05-01-2020
    Location
    Sofia, Bulgaria
    MS-Off Ver
    365
    Posts
    2

    Question Excel flashcard spreadsheet.

    Hi guys i need a little bit of help with excel. I have a worksheet which haves 3 columns. A:word in english;B:word in my language;C:checking if the word i wrote is correct(T or F). i need to make on another sheet everytime there is "f" a word to increment a cell value. It would be better if it can be done to calculate the incrementing on button click.

    For example : A:"one";B:"2";C:"F". and on button click everytime i write "2" and click on the button i want the number in cell in another sheet to increment by 1.

    This is the first sheet :
    colum a(number with letters)
    colum b(number with digits)
    colum c(True or False)
    one
    2
    F
    two
    2
    F
    "one" is "F" in third column because obviously "one" is not "2" (in number).

    I want on second sheet this :
    column a(number)
    column b(count how many times the result was "F")
    one
    1
    two
    0
    I want everytime i recalculate or click on a Command Button(Activex control), column b to increment with +1 if the result is "F" again, and if it is "T" to stay the same value (+0)

    I am not 100% sure if this whole thing can happen, and if it can i am not sure it haves to be with vba/macros :/
    I have attached example .xls file.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Excel flashcard spreadsheet.

    Hi, I have made something like this, maybe you can work with it:
    Please Login or Register  to view this content.
    I have created some dynamic range-names, so that the proper range is always in the formulae.

    BTW, your file was originally saved in the old fileformat (.XLS). If you are really working with Excel97, this will not work.

    Cheers
    Erwin
    Attached Files Attached Files
    I started learning VBA because I was lazy ...
    Still developing.... being more lazy...

  3. #3
    Registered User
    Join Date
    05-01-2020
    Location
    Sofia, Bulgaria
    MS-Off Ver
    365
    Posts
    2

    Re: Excel flashcard spreadsheet.

    Yeah but if i recalculate the "four", "six" and "seven" it does not increment the count...

  4. #4
    Valued Forum Contributor Eastw00d's Avatar
    Join Date
    02-29-2020
    Location
    Breda, NL
    MS-Off Ver
    2016, 2019
    Posts
    833

    Re: Excel flashcard spreadsheet.

    but you have to set the values of column C to "T"...
    I cannot give you a formula for that as I do not know what criteria to use

    Cheers
    Erwin

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Flashcard vocabulary
    By RJ1969 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-01-2019, 07:04 PM
  2. Replies: 0
    Last Post: 04-29-2019, 11:00 AM
  3. Replies: 3
    Last Post: 03-19-2018, 01:49 AM
  4. Using Excel as flashcard
    By davidingilbert in forum Excel General
    Replies: 11
    Last Post: 11-22-2017, 02:17 PM
  5. Replies: 2
    Last Post: 03-18-2015, 01:00 AM
  6. Database for flashcard-style learning
    By Volkanismo in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-24-2011, 10:41 AM
  7. Replies: 1
    Last Post: 02-08-2005, 06:06 AM

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