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

See ans in your other post in .Excel ng. Pls don't multi post as we read em
all.

--
Don Guillett
SalesAid Software

"Mauro" wrote in message
.. .
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