Using user form choose two columns and find duplicates values

**midexlis** · 07-15-2009, 09:30 AM

Hello!

I have a problem. I need to create user form with two listbox (possibly - input box) , who may be attributed to two different columns. When choose two columns, need to find duplicates values and mark different color same values. Is it possible?

I would very much appreciate for advice

**midexlis** · 07-22-2009, 02:20 AM

Bump - no response. Title changed

**midexlis** · 07-27-2009, 09:33 AM

Bump - no response. Title changed

**StephenR** · 07-27-2009, 09:52 AM

Not sure it needs to be that complicated, but I think it would help if you attached a sample workbook illustrating what you want.

**midexlis** · 07-28-2009, 03:03 AM

Originally Posted by StephenR

Not sure it needs to be that complicated, but I think it would help if you attached a sample workbook illustrating what you want.

I attached a example workbook. Numbers are in A B D and F columns. I would like to in user form enter the number of columns. For example: first column - A, second - B and then run ColorDuplicates (Module1). Next time i'd like to select first column - B, second - F and etc.

Is this possible?

Sorry for my bad language