Working with Tab settings in text
Problem
You have a common set of tab stops that you'd like to apply to multiple text boxes.
Adding the tab stops manually to each text box is VERY tedious.
And that's being kind.
Solution
Select a text box that has the tab stops you want already set.
Run the GetTabStops macro below to memorize the tab settings.
Then select another text box and run SetTabStops to apply the memorized tab settings.
Then another. Click. And another. Click. This is fun! Click. And more ... Click click clickclickclick....
Option Explicit Public atabs() As String Sub GetTabStops() ' Select the text whose tab stops you want to pick up then run this macro Dim x As Long With ActiveWindow.Selection.ShapeRange(1) With .TextFrame.Ruler Debug.Print .TabStops.Count If .TabStops.Count > 0 Then ReDim atabs(2, 1 To .TabStops.Count) As String For x = 1 To .TabStops.Count Debug.Print .TabStops(x).Position & vbTab & .TabStops(x).Type atabs(1, x) = CStr(.TabStops(x).Position) atabs(2, x) = CStr(.TabStops(x).Type) Next End If End With End With End Sub Sub SetTabStops() ' Run this macro to apply the memorized tab stops to the selected text Dim x As Long With ActiveWindow.Selection.ShapeRange(1) With .TextFrame.Ruler For x = 1 To .TabStops.Count .TabStops(x).Clear Next For x = 1 To UBound(atabs, 2) .TabStops.Add Type:=CLng(atabs(2, x)), Position:=CDbl(atabs(1, x)) Next End With End With End Sub
See How do I use VBA code in PowerPoint? to learn how to use this example code.