kate: If you read posts 2 & 3 in this thread, you will see that a macro was suggested (and a link to one provided), but the response was "Thought I could make my life a bit easier, but no chance of that." That makes it fairly obvious a macro such as you've posted isn't a solution in this case, apart from which, it doesn't address the underlying issue of the OP wanting the formatting to occur as the data are entered. The only ways of achieving that are as outlined in posts 2 & 4.

PS: When posting code, please use the code tags. They're on the 'Go Advanced' tab at the bottom of this screen.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]