How to change text to uppercase in a column on entry

I am just about to start a large worksheet in which I want all the text entered into column A to be upper case, and all other columns to be Sentence case. I have some code which forces all input to all columns into uppercase, as follows

Please Login or Register  to view this content.

[/INDENT]
Can the Range be specified as column A only? and can I then specify columns B to I as Sentence format?

TIA

Geoff

Hi Glio, maybe something like this:

Please Login or Register  to view this content.

If you have real sentences then you could put this in a module: (haven't tested the function)

Please Login or Register  to view this content.

This would then allow you to change the B:I bit of the change event to:

Please Login or Register  to view this content.

Arkadi,
Thanks very much for both those scripts. They have done exactly what I wanted. I'm not sure what you meant with the Target.value bit, but just putting the module in has worked. Thanks so much for an almost immediate answer.

In a change event, Target is the cell (or cells) that changed, triggering the change event to fire in the first place. Target is the range that changed, so Target.Value is the value of that cell/Range