+ Reply to Thread
Results 1 to 2 of 2

VBA to choose between equally likely possibilities

  1. #1
    Registered User
    Join Date
    05-20-2008
    Posts
    10

    VBA to choose between equally likely possibilities

    Hello,

    What's the best way to have vba choose from equally likely possibilities?

    So, if I have a list of names and I want to pick three of them, but I've no preference for any combination over any other. What's the best way to achieve this?

    Any help much appreciated.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    Store the information about all possible choices and then use RND to select.

    Or you could just take the first occurance(s)
    Cheers
    Andy
    www.andypope.info

+ 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. VLookup or Choose Function?
    By Geforce in forum Excel General
    Replies: 7
    Last Post: 04-28-2008, 12:13 PM
  2. How do I use VBA to choose the source cells for a list with Data Validation?
    By baconcow in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 03-11-2008, 05:36 PM
  3. Choose database
    By Leovanwinden in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2007, 06:01 AM
  4. Going insane!
    By kik in forum Excel - New Users/Basics
    Replies: 10
    Last Post: 01-31-2007, 08:21 AM
  5. choose function challenge
    By marcmarc in forum Excel General
    Replies: 3
    Last Post: 11-18-2006, 01:42 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