Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-22-2023, 12:47 PM
RaymondB RaymondB is offline How do I convert a line of text to title case? Windows 10 How do I convert a line of text to title case? 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
Reply

Tags
text conversion, title case



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
How do I convert a line of text to title case? True Title Case for First Row of All Tables Marrick13 Word VBA 14 12-11-2013 09:12 PM
How do I convert a line of text to title case? Custom Text Filter for this particular case tinfanide Excel 2 09-13-2011 05:08 AM
How do I convert a line of text to title case? From all UPPER CASE to Proper Case davers Word 1 04-30-2009 12:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft