Check Userform controls for identical values

[Newbie_Nick]

Hi all,
I have a userform with 6 separate date pickers. I need to check if any of the dates the user selects are equal to one another so I can generate an error message. The only way I know how to do this is pretty dumb - using 15 IF Structures...

Also it would be nice to know if they are all in ascending order.
Can anyone help me with a more elegant solution?

Thanks a lot!
Nick

[royUK]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[foxguy]

I can easily do it with conditional formatting in a worksheet, as in this workbook Date Conditional Formatting.xls
Look at the conditional formatting in the cells, and adapt it to your textbox_change events in your userform.
Or if you attach a workbook with a sample form as royUK suggests, someone can apply it for you.