?
Solved

VBA to return Heading Number of numbered paragraph

Posted on 2013-05-17
2
Medium Priority
?
1,304 Views
Last Modified: 2013-05-19
Hi All

I would like to find the heading numbers of the selected paragraph using VBA - thought this would be simple but I am flummoxed.

Eg.  I am using outline numbering or heading numbering and my text looks like this:

1.   Trees
1.1 Gum
1.2 Oak
1.3 Terpentine

My cursor is on Oak.  I want VBA to return "1.2"
0
Comment
Question by:DrTribos
1 Comment
 
LVL 15

Accepted Solution

by:
DrTribos earned 0 total points
ID: 39176444
Never mind... I got it..
Sub getP()
Dim pPara As Paragraph
Dim sPara As String
Dim rPara As Range

Set pPara = Selection.Paragraphs(1)
Set rPara = pPara.Range
Debug.Print rPara.ListFormat.ListString & " " & rPara.Text

End Sub

Open in new window

0

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This article describes how to use a set of graphical playing cards to create a Draw Poker game in Excel or VB6.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question