+ Reply to Thread
Results 1 to 2 of 2

Automatically generate random letters after typing

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

    Automatically generate random letters after typing

    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

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

    Re: Automatically generate random letters after typing

    You could add this to the sheet module
    Please Login or Register  to view this content.

+ 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. Random, but not quite random... I'd like to generate combos with set rules...
    By LottoLinks in forum Excel Formulas & Functions
    Replies: 38
    Last Post: 01-05-2019, 08:46 PM
  2. Generate random Alphanumeric with two letters and three numbers
    By Ochimus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2015, 09:19 PM
  3. Need to generate a random serial number that automatically populates the transmittal sheet
    By chriscole412 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-15-2012, 12:52 PM
  4. [SOLVED] Generate random 6-16-byte random hexadecimal number
    By jsamuelshn in forum Excel General
    Replies: 6
    Last Post: 07-20-2012, 10:38 AM
  5. [SOLVED] Ordering random letters for a chance-random based TV gameshow.
    By Askalian in forum Excel General
    Replies: 4
    Last Post: 06-19-2012, 02:26 PM
  6. Function to Generate Random Numbers and Letters
    By jason_kelly in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-14-2010, 03:39 PM
  7. generate a random number and use if function to generate new data
    By Dogdoc1142 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-25-2006, 10:50 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