Written by Allen Wyatt (last updated October 31, 2023)
This tip applies to Word 2007, 2010, 2013, 2016, 2019, and 2021
As part of a macro, you may have a need to work with information stored in a bookmark. For instance, you may need to extract the text in a bookmark, assign it to a variable, and then do some processing based on the variable contents.
There are two ways you can assign the contents of a bookmark to a variable in a VBA macro. The first is to simply jump to the bookmark and select it, then make the variable equal to the contents of the selection. The following code lines will perform this action for a bookmark named MyBookmark:
Dim sMyString As String Selection.GoTo What:=wdGoToBookmark, Name:="MyBookmark" sMyString = Selection.Text
If you don't want to change the selection within the document, you can also simply work with the Bookmarks collection maintained by Word. Assuming you still need the contents of the MyBookmark bookmark, the following code will do the trick:
Dim sMyString As String sMyString = ActiveDocument.Bookmarks("MyBookmark").Range.Text
Note that the name of the bookmark ("MyBookmark") doesn't have to be a static value as shown in both of these examples. If you want, you could simply replace the static value with a variable, as shown here:
Dim sMyString As String Dim sBName As String sBName = "Boilerplate" Selection.GoTo What:=wdGoToBookmark, Name:=sBName sMyString = Selection.Text
In this example, the bookmark name (the one whose contents you want to grab and place into sMyString) is contained within the sBName variable. As you develop your own code, you could easily create a way for a user to enter a bookmark name and just assign it to the sBName variable.
Note:
WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (8876) applies to Microsoft Word 2007, 2010, 2013, 2016, 2019, and 2021. You can find a version of this tip for the older menu interface of Word here: Setting a VBA Variable From a Bookmark.
Create Custom Apps with VBA! Discover how to extend the capabilities of Office 2013 (Word, Excel, PowerPoint, Outlook, and Access) with VBA programming, using it for writing macros, automating Office applications, and creating custom applications. Check out Mastering VBA for Office 2013 today!
Want to get to a bookmark location quickly? One option is to use the F5 key to jump to a bookmark. Perhaps a quicker ...
Discover MoreBookmarks are a handy way to "mark" locations within a document. If you are creating a macro that processes the document ...
Discover MoreBookmarks are a great boon in developing and working with documents--"until someone deletes them. When it comes to ...
Discover MoreFREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Word that uses the ribbon interface (Word 2007 or later)? This site is for you! If you use an earlier version of Word, visit our WordTips site focusing on the menu interface.
Visit the WordTips channel on YouTube
FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments