Thanks. You solved the problem for me, too.

Jim

"Frank Kabel" wrote:

Hi
then see:
http://www.cpearson.com/excel/case.htm
and use the worksheet_change event

--
Regards
Frank Kabel
Frankfurt, Germany

Colin James wrote:
Thanks Frank,
but that just gives an error if it's not uppercase. I really need to
change the entry to uppercase if someone enters it in lower. I think
it may be impossible without writing a macro to check after each
entry and then overwriting the entry.
Colin

"Frank Kabel" wrote:

Hi
you could use a custom validation. e.g. for cell A1 goto 'Data -
Validation' and enter the formula
=EXACT(A1,UPPER(A1))

--
Regards
Frank Kabel
Frankfurt, Germany

Colin James wrote:
Does anyone know of a way that I can force cell entries to be
uppercase?