This code works well for small numbers of phrases but when run on 11 phrases it generates an unhandled exception error
(possible because its calculating 39916800 possible combinations and exhausts memory? not sure...)
Pinky98s example works great for only 4 words in the strTotalString. But I need something for a string with like 178 words and need all combination with 3 words. Anyone knows what I have to change in the code to achieve this?
The logic to do some thing like this would be completely different.
All you do it loop through the string masking each alternate sub string.
strTotalString = "mp3 rock hard prog"
SubStrings = Split(strTotalString, " ")
For i = LBound(SubStrings) To UBound(SubStrings)
Combinations(i) = ""
For j = LBound(SubStrings) To UBound(SubStrings)
If (j <> i) Then Combinations(i) = Combinations(i) & " " & SubStrings(j)
what i see in it that no one can understand what u r codeing here.Here some simplicity is required.
Just like that how to implement this code give some simple examples that will execute diretly without increment in this file.Like to add some textbox button names,labels name . How we can know these all.