View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
margie[_2_] margie[_2_] is offline
external usenet poster
 
Posts: 1
Default VB combination code

I am currently writing a scheduling program in VB. The user will enter
several orders let's call them A, B, C, D in 4 rows in the worksheet.
From these orders I would like the code to come up with all
combinations of those 4 orders. For example,

A B C D
A B D C
A C B D
A C D B
B A C D
B A D C

and so on.
I came up with something but it didn't go through all the combinations.


Can anyone help me?


---
Message posted from http://www.ExcelForum.com/