jeffreybrown
Well-known Member
- Joined
- Jul 28, 2004
- Messages
- 5,152
Hi All,
In my spreadsheet, in column C, I have groupings of cells which are grouped by quiz answers. For the most part, the answers are A, B, C, or D, but there are times where the quiz answers could just be A or B. On a couple of occasions, there is a question with A, B, C, D, or E.
What I would like to do with VBA is have these answers filled in randomly. So, for the first block, C6:C9, I would like to randomly assign one of those cells with an answer. Of course, C6 would be A, C7 would be B, and so on.
Then, for instance, C30:C31 is just either A or B. The answers will always only be letters. A thru D, and sometimes E.
If it helps, all of these cells have an Interior.ColorIndex of 19. Is this possible?
In my spreadsheet, in column C, I have groupings of cells which are grouped by quiz answers. For the most part, the answers are A, B, C, or D, but there are times where the quiz answers could just be A or B. On a couple of occasions, there is a question with A, B, C, D, or E.
What I would like to do with VBA is have these answers filled in randomly. So, for the first block, C6:C9, I would like to randomly assign one of those cells with an answer. Of course, C6 would be A, C7 would be B, and so on.
Then, for instance, C30:C31 is just either A or B. The answers will always only be letters. A thru D, and sometimes E.
If it helps, all of these cells have an Interior.ColorIndex of 19. Is this possible?