Hi, Anybody can help me to make a macro to convert text in a textbox to TITLE CASE. TJ
T Thejan Mendis Oct 8, 2003 #1 Hi, Anybody can help me to make a macro to convert text in a textbox to TITLE CASE. TJ
R Ren? Probst Oct 8, 2003 #2 hello Assuming it is the first Textbox (or better the first Shape) within the main story in the document, than like this: Sub TestJ() Dim oRange As Range Set oRange = ActiveDocument.Shapes(1).TextFrame.TextRange oRange.Case = wdTitleWord End Sub Greatings René Probst Switzerland
hello Assuming it is the first Textbox (or better the first Shape) within the main story in the document, than like this: Sub TestJ() Dim oRange As Range Set oRange = ActiveDocument.Shapes(1).TextFrame.TextRange oRange.Case = wdTitleWord End Sub Greatings René Probst Switzerland
M Mark Tangard Oct 8, 2003 #3 In the textbox's _Exit event, use: TextBox1.Text = StrConv(TextBox1.Text, vbProperCase)