I have this sheet. All data is input through an userform. I now need to make
sure that data is not input twice... I mean... it can be input twice but I
need to send a warning to the operator and I need both identical lines to be
shown (in an userform?) with the choice to
a. accept the input
b. delete one of the 2 entries

to avoid problems I would like to know if it is possible to format the cells
in the sheet so that no matter what the operator writes the caracters are
always capital....

I hope I make any sense....

thanks