#16
|
|||
|
|||
Quote:
If not for the trimming and replacement of double spaces, formatting could be preserved by replacing Code:
.Text = StrTmp Code:
Dim i As Long For i = 1 To .Characters.Count .Characters(i).Text = Mid$(StrTmp, i, 1) Next |
#17
|
||||
|
||||
Did you at least try the code in post #3?
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#18
|
|||
|
|||
Yes, I entered in all the code in post #3 and ran the second snippet on a selection in which some words were in a different font. Character formatting was lost.
|
#19
|
|||
|
|||
Hi Macropod, I would like to use the code in post #3 to format the text in a text box in a user form. I'm very much a VBA novice so any help would be appreciated.
Thanks Raymond |
#20
|
||||
|
||||
RaymondB7777
Text in a vba User Form is normally typed in by the user. Are you planning on running this code to re-constitute what the user typed or are you populating the text box in code? Perhaps you need to attach a document that shows what you already have and what the macro needs to do?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#21
|
|||
|
|||
Another note, just so you understand, the first macro was for text in the document, not text in a userform. I am confident that wiser heads than I can adjust for that, but it is a different thing.
If I were doing it, I would need to create a new document, put the text in that document, and then run the code. Then copy the reformatted text from the temporary document, delete that document, and put it in the userform. |
#22
|
|||
|
|||
Hi guys, I should have been clearer .
What I want to be able to do is reconstitute what the user typed in the Text Box. Currently what I use is very simple and works well to change the text in the text box (TextBoxSection) to vbProperCase. Private Sub TextBoxSection_Change() Me.TextBoxSection = StrConv(TextBoxSection, vbProperCase) End Sub Instead of changing it to vbProperCase, I would like it to format it in line with what Macropod's code does to selected text in the actual document. I have saved that code and have used it successfully in various documents. Thank you. |
Tags |
text conversion, title case |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
creating a new TITLE property from text already within document | smndnm | Word VBA | 6 | 07-04-2014 08:27 PM |
Stop review query when small case at beginning of line | dsrose | Word | 2 | 01-22-2014 12:19 AM |
True Title Case for First Row of All Tables | Marrick13 | Word VBA | 14 | 12-11-2013 09:12 PM |
Custom Text Filter for this particular case | tinfanide | Excel | 2 | 09-13-2011 05:08 AM |
From all UPPER CASE to Proper Case | davers | Word | 1 | 04-30-2009 12:41 PM |