I have a Word document with multi-level headings -- table of contents, styles Heading 1-n, all that. When I pull up the Navigation Pane and move the text cursor within the document, the Navigation Pane highlights the heading closest to the cursor position. Isn't there some way get what that heading is in VBA -- some property of the Range or Selection object? Thanks.
Last edited by jjasmith4; 04-19-2019 at 05:40 PM.
the VBA sytax for returning the selected cell is 'Selection"
Please Login or Register to view this content.
Last edited by JLGWhiz; 04-19-2019 at 04:27 PM.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
JLGWhiz: Your reply has nothing to do with the OP's question.
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Umm, this is in Word, not Excel. FYI use vbCrlf in messageboxes, not vbLf.Originally Posted by macropod
Try:
MsgBox Selection.Range.GoTo(What:=wdGoToHeading, Which:=wdGoToPrevious).Paragraphs.First.Range.Text
or:
MsgBox Selection.Bookmarks("\HeadingLevel").Range.Paragraphs.First.Range.Text
Last edited by macropod; 04-21-2019 at 06:04 PM.
Cross-posted at: https://stackoverflow.com/questions/...-the-selection
Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
@macropod
Guess I need to start reading these a litrtle closer.
vbLf will work also, unless you have a carraige on your system that needs to return.
As will vbCrvbLf will work also, unless you have a carraige on your system that needs to return.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks