+ Reply to Thread
Results 1 to 9 of 9

Automatisch random letter genereren na typen

  1. #1
    Registered User
    Join Date
    08-08-2016
    Location
    Belgium
    MS-Off Ver
    Windows 7
    Posts
    5

    Automatisch random letter genereren na typen

    Dag allemaal,

    Ik probeer een macro te bouwen om een vriend te leren "blind typen".
    Hiervoor wil ik een random letter op het scherm laten komen in cel B5 die hij moet na typen in cel C5. Is de letter juist dan komt de volgende letter. Is de letter fout getypt dan wordt het cel waar de random letter in staat rood en moet hij nog eens proberen.

    Om het programma te laten starten moet die persoon op de knop 'Start' duwen. Dit is al gelukt, duw ik op start dan komt er telkens een nieuwe random letter in de cel. Maar wat ik wil verkrijgen en me niet lukt is dat na het drukken op start het programma blijft lopen en telkens wanneer iemand eender welke letter intypt het programma reageert met ofwel een nieuwe letter of een rode kleur bij fout.

    Kan iemand me hier bij helpen?

    Alvast bedankt.

    mvg
    Bjorn
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: Automatisch random letter genereren na typen

    bjorn, dit is een engelstalig forum, dus de vraag graag in het engels gesteld. Anders de vraag posten bij de andere talen.

    Bjorn, this is an english forum, so please ask the question in english. Otherwise post the question by other language.
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  3. #3
    Registered User
    Join Date
    08-08-2016
    Location
    Belgium
    MS-Off Ver
    Windows 7
    Posts
    5

    Automatically generate random letters after typing

    Excuse me for the dutch message, i'll translate it:

    Hello everybody,

    I'm trying to build a macro for a friend to teach him how to type blindly.
    Herefor i want to let a random letter pop up in cel B5 after clicking on the 'START' button. After this the person has to type the letter in cel C5.
    If the typed letter is correct then the next letter pops up in cel B5, automatically. If the letter is typed wrong, cel B5 turns red and the person typing has to try again until it is right, then the back color of cel B5 turns white again.

    To start the 'program' the person has to press the 'START' button only once, in the beginning.

    Some things already work. Each time i press the START button, a random letter is generated in cel B5.
    What doesn't work is the 'automatic' part. If i press START the program should sustain and keep going.

    Can anyone help me with this?

    Thanks in advance.

    Bjorn
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    08-08-2016
    Location
    Belgium
    MS-Off Ver
    Windows 7
    Posts
    5

    Re: Automatisch random letter genereren na typen

    Anyone any ideas?

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Automatisch random letter genereren na typen

    You'll need to translate the title of your original post into English.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  6. #6
    Registered User
    Join Date
    08-08-2016
    Location
    Belgium
    MS-Off Ver
    Windows 7
    Posts
    5

    Re: Automatisch random letter genereren na typen

    Crap, i forgot. Thanks for mentioning. Eventhough changing the original title isn't quit working out. I'll start a new thread.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,719

    Re: Automatisch random letter genereren na typen

    No, don't do that. Locate a mod and ask them to edit the title for you. Duplicate threads will be closed.

  8. #8
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,758

    Re: Automatisch random letter genereren na typen

    You could perhaps use a macro like this to toggle color to red if letter wrong and if letter in C5 right font is set to black and your macro "letter" is run.

    Please Login or Register  to view this content.
    Right click on tab Blad1 and click on "View code" and paste this code in the windows that opends.

    Alf

    Ps A small gilch in your uploaded file letter is in B5 but macro is set to change Chr in B6
    Last edited by Alf; 08-10-2016 at 10:12 AM.

  9. #9
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Automatisch random letter genereren na typen


+ 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. Replies: 8
    Last Post: 04-27-2016, 01:25 PM
  2. [SOLVED] Mutatie automatisch doorvoeren
    By vrijndam in forum Excel General
    Replies: 6
    Last Post: 10-23-2015, 01:16 AM
  3. [SOLVED] Random letter from pool (A,B,C)
    By Vestlink in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-22-2014, 07:27 AM
  4. [SOLVED] Random letter or number
    By zyzzyva57 in forum Excel General
    Replies: 8
    Last Post: 03-09-2014, 08:49 AM
  5. Sorting/filtering specific letter/s in a random code
    By squareeyes in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-07-2013, 11:47 PM
  6. Random Letter Copy and paste-Little help for a beginner
    By GerPis in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-02-2012, 09:12 PM
  7. Random letter and number generator
    By Marie1uk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2006, 02:04 PM

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