![]() |
#1
|
|||
|
|||
![]()
Hello i need advice. I work with multiple files where there is a pile of text boxes.
In all I need to set up: scale: 100%; space: normal; position: normal. Currently I have to click in each text box to select the text and set it, which is very time consuming for 200 text boxes. Couldn't it be made easier by some macros? Thanks for helping me. |
#2
|
|||
|
|||
![]()
solved, I used:
Code:
Sub SetTextBoxStyle() Dim oShape As Shape, objDoc As Document, oInnerShape As Shape Application.ScreenUpdating = False Set objDoc = ActiveDocument For Each oShape In objDoc.Shapes If oShape.Type = msoGroup Then For Each oInnerShape In oShape.GroupItems FormatAShape oInnerShape Next oInnerShape Else FormatAShape oShape End If Next oShape Application.ScreenUpdating = True End Sub Function FormatAShape(oShape As Shape) With oShape If .TextFrame.HasText Then ' .TextFrame.TextRange.Font.TextColor.RGB = RGB(8, 8, 8) ' Set text color. .TextFrame.TextRange.Font.Size = 9 ' Set text size. .TextFrame.TextRange.Font.Name = "Arial Narrow" ' Set font face. .TextFrame.TextRange.Font.Spacing = 0 ' Set character spacing. .TextFrame.TextRange.Font.Scaling = 100 ' Set character spacing. .TextFrame.TextRange.Font.Position = 0 ' Set character spacing. End If End With End Function but i still need to set the bullets - scale: 100%; space: normal; position: normal. and somehow I can't. I need in the document for all bullets and numbering rewrite the format |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Formatting connectors and text boxes | SargeUSMC | Visio | 1 | 08-30-2021 05:12 PM |
Macro to Formatting Text Boxes | effimera | Word VBA | 3 | 07-01-2021 03:10 AM |
![]() |
ianmck | Drawing and Graphics | 5 | 06-28-2018 09:04 PM |
![]() |
RHODIUM | Word | 6 | 10-01-2016 04:43 PM |
![]() |
TzarChasm | Word | 7 | 04-14-2016 06:28 PM |