Capitalising letters after . or ? or !

[francesw]

Hi

The problem I'm currently having is that I want my macro to capitalise a letter that comes after the end of any sentence - at the minute it only capitalises a letter if it comes after a full stop (period for any americans reading!). Essentially what I want is to turn

this sentence isn't written properly. why not? people can't be bothered to press shift! it's annoying.

into

This sentence isn't written properly. Why not? People can't be bothered to press shift! It's annoying.

The part I've highlighted in red is the part that currently puts a capital letter after a full stop. I'm new to VBA but I'm now thinking that as well as needing ? and ! adding in, the way it's been done is definitely not the most efficient? Am I right? I've found a couple of things similar on other forums e.g:

http://stackoverflow.com/questions/1...case-using-vba

http://www.vbforums.com/showthread.p...-each-sentence

But nothing seems to do exactly what I want which is to change this text in the original cell. I've tried using trial and error to fix some codes that do similar things but nothing seems to work - I can get them to run eventually without an error but they either just delete all the text out or do nothing.

Please Login or Register  to view this content.

Any help would be really appreciated!

I tried to replace it with the code from the stackoverflow forum removing the bit about the message box

Please Login or Register  to view this content.

But currently it just doesn't do anything.

Thanks

[StephenR]

See if this works:

Please Login or Register  to view this content.

[francesw]

Works perfectly! Thanks so much!

[swoop99]

<Pedantic nitpicking hat on> If you want to be really accurate then all stop characters like . ? or ! should have a double space after them before the capital letter.

[StephenR]

I'd say I was pretty pedantic about such things, but I don't agree. I think it's a matter of opinion, but the trend nowadays is for a single space.

[swoop99]

My Mother the typesetter (God rest her soul) would disagree that it's a trend, she'd say a single space is just plain wrong. As for me, I'm a good boy who does what his Mother tells him.