Linking cells to permutation code

[shiqs28]

HI,

Until now I have managed to create permutation of items using VBA code.

When I run the code, I have to type the items I want to permute and the program will automatically generate all the permutations.
(Which in this case is limited to 5 items)

The problem I'm having now is that instead of typing the items that I want to permute,
I would like to use a CommandButton named INSERT to automatically assign the value from cell E50 - E54
into the permute userform.



ATTACHED IS MY PROJECT WORK.
Any kind help is highly appreciated.

Advance Thank You.