MsgBox listing all outline level 1 headings

Dear Experts:
Below macro lists all outline level 1 headings in a msgbox. Can this macro be expanded to list also the paragraph style name in the msgbox such as:

Section 3: List of Tables, Heading_List
Section 4: List of Figures, Heading_List
Section 5: 1 Introduction, Heading 1
Section 6: 2 Analysis, Heading 1
........
Section 12: Bibliography, Heading_End
Section 13: Appendix, Heading_End

Help is much appreciated. Thank you very much in advance.

Regards, Andreas
Sub ListOutlineLevel1ParaMsgBox()
Dim oPara As Paragraph
Dim strMsg As String
Dim rTmp As range ' a temporary range
Dim lTmp As Long  ' sections count
Dim l2Tmp As Long
 
Set rTmp = ActiveDocument.range
'Create start of message
strMsg = "Outline Level 1: " & vbCr
'Iterate through all paragraphs in active document
'If style has outline level 1, append to message
For Each oPara In ActiveDocument.Paragraphs
   If oPara.OutlineLevel = wdOutlineLevel1 Then
'   strMsg = "Outline level 1: " & vbCr
 
      With oPara.range
      rTmp.End = .End ' redefine the temporary range
      lTmp = rTmp.Sections.count ' count the sections
     
      
      'Append the heading number and text to the message
      strMsg = strMsg & " section: " & CStr(lTmp)
      strMsg = strMsg & "  " & .ListFormat.ListString & "  " & .Text _
      & "  "
      
      End With
      End If
Next oPara
MsgBox strMsg, vbOKOnly, "Summary Outline Level 1"
End Sub

Open in new window

Andreas HermleTeam leaderAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Chris BottomleySoftware Quality Lead EngineerCommented:
Hello AndreasHermle,

Keeping with what you have and making small changes ... try the following

Regards,
Chris
Sub ListOutlineLevel1ParaMsgBox()
Dim oPara As Paragraph
Dim strMsg As String
Dim rTmp As Range ' a temporary range
Dim lTmp As Long  ' sections count
Dim l2Tmp As Long
 
Set rTmp = ActiveDocument.Range
'Create start of message
strMsg = "Outline Level 1: " & vbCr
'Iterate through all paragraphs in active document
'If style has outline level 1, append to message
For Each oPara In ActiveDocument.Paragraphs
   If oPara.OutlineLevel = wdOutlineLevel1 Then
'   strMsg = "Outline level 1: " & vbCr
 
      With oPara.Range
      rTmp.End = .End ' redefine the temporary range
      lTmp = rTmp.Sections.Count ' count the sections
     
      
      'Append the heading number and text to the message
      strMsg = strMsg & " section: " & CStr(lTmp)
      strMsg = strMsg & "  " & .ListFormat.ListString & "  " & Left(.Text, Len(.Text) - 1) & _
      vbTab & oPara.Range.Font.Name & vbCrLf
      
      End With
      End If
Next oPara
MsgBox strMsg, vbOKOnly, "Summary Outline Level 1"
End Sub

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Andreas HermleTeam leaderAuthor Commented:
Dear Chris,
thank you for your professional help. I slightly changed the code to "oPara.range.Style" instead of "oPara.range.Font.Name" (at the very end before "End With") . My requirment was actually to add the paragraph style name.  With your help I was able to change that myself.

Again, thank you for your professional help. Regards, Andreas
0
Chris BottomleySoftware Quality Lead EngineerCommented:
Apologies for my oversight and well done to correct it yourself

Chris
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Word

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.