Formatting text in textbox

[AndyE]

It have a textbox in a userform that allows users to enter "free text" into it in response to a question prior to submitting it to a word document. The following code recognises where a full stop and been inserted and changes the next word into Proper Case.

It fails to work however when a carriage return is introduced, i.e. when introducing paragraphs.

How may this be resolved?

Please Login or Register  to view this content.

[macropod]

If you're inserting the content directly into the document, you can use code like:

Please Login or Register  to view this content.

Leaving aside the question of what I'm inserting, the above code sets a range object to point to the destination (in the case, the start of the document), inserts the content, then uses Word's own tools for the sentence case conversion.

[AndyE]

Sorry, I'm not sure what the above is all about...

The code I displayed changes the case of the text as the user types into the box.

I'm not sure how or where you run the code you've provided. I inserted it and as soon as I ran the userform I got a page and a half of the text located within your code.

[macropod]

Perhaps:

Please Login or Register  to view this content.

[AndyE]

The sentences appear correct up to the point where I hit enter to create a carriage return and word crashes....

[macropod]

That's sad. Try:

Please Login or Register  to view this content.

[AndyE]

Run the above and I get the error message...


"Run time error '5': Invalid procedure call or arguement

highlighting this this line,

Please Login or Register  to view this content.

[macropod]

OK, have a go with this version of the Function:

Please Login or Register  to view this content.

Intentionally, the function does not capitalize a letter immediately after one of the nominated punctuation characters - there must be a space between them. If you need a variation on that theme let me know.

[AndyE]

That is absolutely spot on...exactly what I wanted...

much appreciated,

thank you.