Random Picker for Excel by Crystal
Printed From: Roger's Access Library
Category: Other Download Libraries
Forum Name: Long, Crystal
Forum Description: Access Basics is designed for those of you with a thirst to understand the fundamentals of Access with programming in mind ... whether you realize it or not.
URL: www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=587
Printed Date: 19 Apr 2024 at 3:51pm Software Version: Web Wiz Forums 12.03 - http://www.webwizforums.com
Topic: Random Picker for Excel by Crystal
Posted By: Crystal Long
Subject: Random Picker for Excel by Crystal
Date Posted: 24 May 2012 at 9:39am
uploads/84/Random_Picker_by_Crystal_120318__XLS.zip - 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) |
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 - 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 - http://www.AccessMVP.com/strive4peace Free 100-page book that covers essentials in Access
http://www.YouTube.com/LearnAccessByCrystal - 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 ~
|
|