View Single Post
 
Old 02-22-2023, 12:47 PM
RaymondB RaymondB is offline Windows 10 Office 2019
Novice
 
Join Date: Jan 2020
Posts: 1
RaymondB is on a distinguished road
Default

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.
Reply With Quote