+ Reply to Thread
Results 1 to 2 of 2

How to put the first three words to appear at random location on each bingo card?

Hybrid View

  1. #1
    Registered User
    Join Date
    10-24-2013
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    20

    How to put the first three words to appear at random location on each bingo card?

    I downloaded attached the buzzword bingo Excel file from internet. There are 30 buzzwords in worksheet “Words”. However, I need the first three words A, B and C to appear at random location on each card.

    Thank you very much for help in advance.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,080

    Re: How to put the first three words to appear at random location on each bingo card?

    This works

    Sub k1()
    numCards = Worksheets("Words").Cells(3, 2)
    For i = 1 To numCards
    For j = 1 To 3
    n = 0
    Do Until n = 1
    k = Int(Rnd() * 3) + 1
    l = Int(Rnd() * 3) + 1
    m = (i - 1) * 4 + k
    o = Worksheets("Words").Cells(m, l)
    If Not (InStr("ABC", o)) Then
    Worksheets("Cards").Cells(m, l) = Chr(64 + j)
    n = 1
    End If
    Loop
    Next j
    Next i
    End Sub
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

+ 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. Creating random numbers for bingo games
    By dcbeagle in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-11-2018, 01:39 PM
  2. [SOLVED] Bingo Card Generator
    By Zeratul05 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-20-2014, 04:32 AM
  3. [SOLVED] Bingo Card Generator
    By Bob Cook in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-21-2014, 08:41 AM
  4. Replies: 2
    Last Post: 01-21-2014, 09:42 PM
  5. Help needed to make game with bingo random qualities
    By frednufc in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-07-2013, 07:01 PM
  6. Bingo Card
    By sinspawn56 in forum Excel General
    Replies: 6
    Last Post: 10-29-2013, 02:56 PM
  7. [SOLVED] Create random number bingo cards with Excel
    By teachertolawyer in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 09-15-2005, 07:05 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1