+ Reply to Thread
Results 1 to 5 of 5

Bingo call

  1. #1
    Forum Contributor
    Join Date
    10-27-2013
    Location
    Ireland
    MS-Off Ver
    Microsoft 365
    Posts
    403

    Bingo call

    How can i generate random numbers 1 to 90 and only appear once per game? (No Duplicating numbers)

    ive used randbetween function in each of the call boxes. (See file)

    i need to generate a new random number when i press the next number button...... also need help setting that up.

    is it poss to insert a reset button for a new game?

    thank you to you all for ye'r help
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-02-2013
    Location
    Québec
    MS-Off Ver
    Excel 2003, 2007, 2013
    Posts
    1,412

    Re: Bingo call

    Hello Patcheen,

    See file attached. You have one button to call the next number and one button to reset the game.
    Attached Files Attached Files
    GC Excel

    If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.

  3. #3
    Registered User
    Join Date
    11-26-2020
    Location
    United Kingdom
    MS-Off Ver
    Windows 10
    Posts
    4

    Re: Bingo call

    Hi

    This looks like it would be super helpful but when I open the workbook and press the button the VBA appears with an error. Any way of resolving?

    Many thanks,

    Amy

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,873

    Re: Bingo call

    You might be able to adapt this concept to your specific issue. It creates a standard 25 unit card, but it should be adaptable to your situation.
    Attached Files Attached Files
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Registered User
    Join Date
    10-28-2021
    Location
    Rotterdam, Netherlands
    MS-Off Ver
    365
    Posts
    1

    Re: Bingo call

    Thank you very much, this program is very usefull for me. Ben.

+ 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: 2
    Last Post: 01-21-2014, 09:42 PM
  2. Bingo Card
    By sinspawn56 in forum Excel General
    Replies: 6
    Last Post: 10-29-2013, 02:56 PM
  3. Auto Bingo
    By ChemistB in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-23-2011, 08:45 AM
  4. Bingo in Excel
    By Ludvig73 in forum Excel General
    Replies: 1
    Last Post: 04-12-2010, 11:30 AM
  5. [SOLVED] Bingo Ball
    By Nomis-MCSE in forum Excel General
    Replies: 1
    Last Post: 06-01-2006, 06:55 PM
  6. Bingo Lottery
    By Nomis-MCSE in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2006, 01:25 PM
  7. Bingo
    By shoes in forum Excel General
    Replies: 1
    Last Post: 03-01-2006, 08:00 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