+ Reply to Thread
Results 1 to 12 of 12

Using Excel as flashcard

  1. 11-20-2017, 03:29 PM #1
    davidingilbert
    davidingilbert is offline
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Using Excel as flashcard

    Hello all - I am attempting to use Excel as kind of a "Flashcard" for my son to help him learn his multiplication tables.

    He needs to learn them up to 12.

    What I was trying to make work was to have Excel choose the numbers between 1 & 12 randomly. He would then input his answer and if his answer was the correct matching answer, it would flash a quick message and move on. If the wrong answer, it would display a wrong answer and he would need to try it again.

    I need a bit of a boost to get this going.

    Any help would be appreciated.
    Thanks.
    Dave
    Reply With QuoteRegister To Reply
  2. 11-20-2017, 04:02 PM #2
    6StringJazzer
    6StringJazzer is offline
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: Using Excel as flashcard

    The problem with choosing numbers randomly is as soon as he inputs an answer, Excel will recalculate the random numbers.

    Here is a version with macros that does what you want.
    Attached Files Attached Files
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]
    Reply With QuoteRegister To Reply
  3. 11-20-2017, 06:08 PM #3
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Using Excel as flashcard

    Interesting.

    I created a userform for you to try.

    I am attaching two versions.

    Version two runs when you open the workbook, but with excel hidden.

    Turn the sound up when using these.

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 11-20-2017 at 06:16 PM.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.
    Reply With QuoteRegister To Reply
  4. 11-20-2017, 09:41 PM #4
    davidingilbert
    davidingilbert is offline
    Forum Contributor
    Join Date
    06-03-2009
    Location
    Phoenix, Az
    MS-Off Ver
    MS Office 365
    Posts
    144

    Re: Using Excel as flashcard

    Jazzer - thanks!!!
    Reply With QuoteRegister To Reply
  5. 11-20-2017, 10:37 PM #5
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Using Excel as flashcard

    Quote Originally Posted by mehmetcik View Post
    ...I created a userform for you to try.
    I like your userform a lot. If I may offer a suggestion, use a key_down procedure to trap the ENTER key, so you can skip mouse clicks altogether. 
    Please Login or Register  to view this content.
    Clicking the Add Reputation star below helpful posts is a great way to show your appreciation.
    Please mark your threads as SOLVED upon conclusion (Thread Tools above Post # 1). - Lee
    Reply With QuoteRegister To Reply
  6. 11-21-2017, 01:04 PM #6
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Using Excel as flashcard

    Hi Lee

    I had considered that. But this is for a kid.

    My way allows time for changes.
    Reply With QuoteRegister To Reply
  7. 11-21-2017, 02:15 PM #7
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Using Excel as flashcard

    Well, either way, it's pretty cool! Though the key is just an option... the user can still click the button if preferred.
    Last edited by leelnich; 11-21-2017 at 02:23 PM.
    Reply With QuoteRegister To Reply
  8. 11-21-2017, 07:53 PM #8
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Using Excel as flashcard

    Ok Lee,

    I have improved the code and taken up your suggestion at the same time.

    This version tries to reduce repetition in the last ten entries.

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  9. 11-21-2017, 11:13 PM #9
    leelnich
    leelnich is offline
    Forum Expert leelnich's Avatar
    Join Date
    03-20-2017
    Location
    Delaware, USA
    MS-Off Ver
    Office 2016
    Posts
    2,807

    Re: Using Excel as flashcard

    Quote Originally Posted by mehmetcik View Post
    ...This version tries to reduce repetition in the last ten entries.
    Nice! I noticed some repetition, it's a worthwhile improvement.
    Reply With QuoteRegister To Reply
  10. 11-22-2017, 12:57 AM #10
    krishnakuma6
    krishnakuma6 is offline
    Registered User
    Join Date
    08-30-2012
    Location
    UAE
    MS-Off Ver
    Excel 2016,office 365
    Posts
    69

    Re: Using Excel as flashcard

    Dear mehmetcik,

    This is very useful for my kids.
    Sorry to interupt, Is is this possible to add option for "Add, Subtract and Division" in this same userform?

    Rgds
    Krishna
    Reply With QuoteRegister To Reply
  11. 11-22-2017, 12:32 PM #11
    Richard Buttrey
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Using Excel as flashcard

    Quote Originally Posted by krishnakuma6 View Post
    Dear mehmetcik,

    This is very useful for my kids.
    Sorry to interupt, Is is this possible to add option for "Add, Subtract and Division" in this same userform?

    Rgds
    Krishna
    Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  12. 11-22-2017, 02:17 PM #12
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Using Excel as flashcard

    Please create a new post requesting this improvement.

    Send me the link in a private post and I will happily do that for you.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Database for flashcard-style learning
    By Volkanismo in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 05-24-2011, 10:41 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1