1. M

    Excel VBA Custom Randomizer

    Hi All, I have a macro I'm working on and am having trouble creating a randomizer to find the answer to a solution I'm looking for. Here's the data I need to randomize: Column A contains a Unique ID (1,2,3,4,5 etc) Column B needs to be populated with a number between 1 and 50 but must be...
  2. T

    Question Bank

    How do I create a question and answer bank with excel in a way that I can randomly produce tests with corresponding answer sheets? Also, I need to create multiple choice tests. Little about me: real dumb. Basic instruction and guidance is appreciated. Thanks in advance!
  3. Q

    Question bank for Match the Following

    Tl dr; I am trying to make a question bank where one of the question is match the following and I want to randomly select them to form an assignment. I am trying to make question bank in excel so that I can hand out a separate assignment sheet to each student. There are different types of...
  4. T

    Randomize function

    Following from Rick Rothstein's comment here: https://www.mrexcel.com/forum/excel-questions/747715-rnd-not-truly-random.html he suggests, if I understood him correctly, that you should only ever have the randomize function once. In that case, why not just put it in the Workbook_Open...
  5. T

    Using RAND function

    Question, I have not used this and I need to set up based on 2 criteria I have a column with names in it and a second column with codes in them. I only want 10% of the total codes for each name Name 1 can have 20 codes so I need to randomize the two codes that get audited. Name 2 50 codes so...
  6. S

    Randomizing groups with no repeats

    Hi there, I'm trying to randomize the forms we use for study participants for two different sessions without repeats. Specifically, at session #1 , participants are randomized to receive Form A, Form B, or Form C of the same measure. For session #2 , we want to randomize what form version...
  7. S

    Random number generator - vba

    I have found code online to generate a random number using VBA (on click of button) How do I get it to display a certain cell (H5) rather than in a msgbx? Sub random_num() 'Initialize the random number generator '=> Randomize : add this before you call the Rnd function to obtain...
  8. A

    Generate list of random numbers, using same starting seed

    I have inherited some VBA code in Excel 2016 - when the code is run, 500 users are input one by one, and a random number assigned to each one. As far as I understand, the code uses Randomize and Rnd (-1) to set the same starting seed each time, so that every time 500 users are input the same...
  9. M

    randomize cycle and time useform

    Hi, I've got the following code to randomize through userforms, however I would like it to loop through on a random time frame from 5 minutes to 15 minutes and show for 5 seconds then close. So just say I click the button to start the macro, it shows a random userform for 5 seconds then...
  10. B

    Draw a Random name from a list

    Can anyone please help me with this. I have a command Button on the sheet which I want to run the code to do the following in cells G20 to G100 I have a list of names. The list can be any length - so there might only be 12 names or 20 names but the list always starts at cell G20 and will...
  11. S

    VBA or Formula Randomization Question

    Hello all so I have a couple questions that relate to the same topic. First I'm trying to create a "test" which pulls information, randomly from a different sheet, populates in the "primary" sheet and then upon completion of the test you can type in the box, anything you want and the scoring...
  12. A

    How to randomize a group of numbers, colors and names from a list without repeating them in the line.

    I need to come up with all the combinations for the below data. I have numbers, colors and names. I need to put one number, two colors and three names in a row without repeating a name or color in each row. I would also like to not replicate the rows with the colors or names in a different...
  13. G

    Shuffle/Randomize from list of names

    Hello, Im trying to have a cell populate if conditions are met in 2 others cells (ive been using an If statement). I would like the cell that will populate to pull from a list of names and the results to evenly randomize or just choose from the next name on the list (and start from the...
  14. J

    Syntax question - use of parentheses in rnd and randomize

    Hi there: Here goes a newbie's question. I was playing around with rnd function and randomize statement and noticed that seed values may be entered without the parentheses. I was wondering why such behavior is possible since my understanding was that any paramenters (for functions, at...
  15. S

    Random name shuffle without repetitions

    Hi guys, I've got four columns with numbers and names next to the numbers. It looks something like that: cA cB cC cD 1 Anna 6 Frank 2 John 7 Marva 3 James 8 Alice 4 Craig 9 Keith 5 Paul 10...

Some videos you may like

This Week's Hot Topics