Excel VBA Recursion

Category: excel for developers

Question

Clutchtastic on Fri, 22 Dec 2017 13:48:55


How do I program this in Excal VBA?

I have a variable number of dice. Each dice has a variable number of sides. Once I select how many dice I have and how many sides each dice has, I would like a VBA code to output each combination to excel. The final result would be a list where each row is a possible outcome from the rolling of the dice.

Cheers!

Replies

Ashidacchi on Sat, 23 Dec 2017 00:28:05


Hi Clutchtastic,

I guess you are a student and it is a school assignment. Is this correct?

I suppose it's a matter of combinations and permutations. You need to specify the minimum and maximum value about both the number of dices and the number of faces on each dice. 

Regards,

Clutchtastic on Sat, 23 Dec 2017 15:09:53


Not a student, a working professional trying to write some code for optimization. I am using dice in my question because it is easier to explain than what I am actually using it for. Same principle though.

Yes, I realize that it is a combination issue, but I do not know how to write the code for a user specifying the number of dice, then how many sides of each dice.

ryguy72 on Sat, 23 Dec 2017 15:33:02


This sounds like an academic exercise.  Check out these links.

https://stackoverflow.com/questions/10692653/excel-vba-to-create-every-possible-combination-of-a-range

https://www.extendoffice.com/documents/excel/3097-excel-list-all-possible-combinations.html

Some people confuse combinations (order doesn't matter) with permutations (order matters).  Just in case you want to learn about permutations...

https://www.extendoffice.com/documents/excel/3657-excel-generate-all-permutations.html

Asadulla Javed on Sat, 30 Dec 2017 10:48:38


Can you give some sample. Say you take 3 Dice and each has 4 side. How you need the output.