Can anybody atleast help me with the first part (Combination)? I can
somehow try and manage the Matches and Frequency.

If I enter 3 in the Combinations prompt, it should create 19380
combinations of 3 numbers [ =COMBIN(20,3)*17 ]
if I enter 7 in the Combinations promot, it should create combinations
of 7 numbers.
If the total combinations exceeds 25000 then list only the first 25000
combinations and exit the vba code.

Thanks

Maxi wrote:
Problem : I want to list only those combinations that meets a given criteria.
----------------------------------------------------------------------------------

I need a vba that gives three prompts to the user which asks for
Combinations, Matches and Frequency.

Lets say the user enters:
Combinations (C) : 5
Matches (M) : =4
Frequency (F) : =8

Considering the above criteria, the macro should list combinations of 5
numbers (C) out of which any 4 numbers (M) matches in more than or
equal to 8 draws (F).