Roger's Access Library Homepage
Forum Home Forum Home > Other Download Libraries > MS Access MVP Libraries > Long, Crystal
  New Posts New Posts RSS Feed - Random Picker for Excel by Crystal
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

>
Want a good read? Try The Summer of His Life (available on Amazon!)

Random Picker for Excel by Crystal

 Post Reply Post Reply
Author
Message Reverse Sort Order
Crystal Long View Drop Down
Microsoft MVP
Microsoft MVP


Joined: 21 May 2012
Location: Colorado
Status: Offline
Points: 35
Post Options Post Options   Thanks (0) Thanks(0)   Quote Crystal Long Quote  Post ReplyReply Direct Link To This Post Topic: Random Picker for Excel by Crystal
    Posted: 24 May 2012 at 9:39am
uploads/84/Random_Picker_by_Crystal_120318__XLS.zip

Pick one or more random values from any column of data on a worksheet.

The example workbook contains sample information so you can see how this works.  To use the random picker in another workbook, you will need the userform f_RandomPicker, and the module, mod_RandomPicker_Excel.

1. press Alt-F8 for a list of macros
2. run --> Show_RandomPicker
(make sure you enable macros if this file is not in a Trusted Location)

A UserForm will pop up

Specify:
1. the number of picks you want (ie: 5)
2. the first cell to write picks to (ie: C1)
3. the first cell that has the data you want to pick from (ie: C8)  - make sure there are NO blank rows in the data because Excel will stop looking
4. if multiple picks are desired, you can specify to write the values down (vertical) or across (horizontal)
5. click OK to run the random picker program

each time you click OK, new random values will be generated and will replace what is in the specified cells
it is possible to get duplicates as the code does not check for uniqueness

click Cancel when you are done with the Random Picker form

if you also wish to display the random numbers that were generated next to (or below) each Pick, check --> Write random number(s) also

Using the random picker is demonstrated here:

Learn Excel 2010 - "Random Chooser":Podcast #1531, by Bill "MrExcel" Jelen
http://www.youtube.com/watch?v=aUmiW5j-Uuo

Feedback is appreciated, thank you

Warm Regards,
Crystal

Microsoft MVP
remote programming and training

Access Basics by Crystal
http://www.AccessMVP.com/strive4peace
Free 100-page book that covers essentials in Access

http://www.YouTube.com/LearnAccessByCrystal

 *
   (: have an awesome day :)
 *
Warm Regards,
Crystal
Microsoft MVP
Remote Training & Programming
Let's Connect and Build Together

http://www.AccessMVP.com/strive4peace
http://YouTube.com/LearnAccessByCrystal
~have an awesome day ~
Back to Top
Sponsored Links
>
Want a good read? Try The Summer of His Life (available on Amazon!)

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.03
Copyright ©2001-2019 Web Wiz Ltd.