Please Note: This article is written for users of the following Microsoft Word versions: 97, 2000, 2002, and 2003. If you are using a later version (Word 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Word, click here: Setting a VBA Variable from a Bookmark.

Setting a VBA Variable From a Bookmark

Written by Allen Wyatt (last updated October 25, 2018)
This tip applies to Word 97, 2000, 2002, and 2003


8

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:

If you would like to know how to use the macros described on this page (or on any other page on the WordTips sites), I've prepared a special page that includes helpful information. Click here to open that special page in a new browser tab.

WordTips is your source for cost-effective Microsoft Word training. (Microsoft Word is the most popular word processing software in the world.) This tip (1595) applies to Microsoft Word 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Word (Word 2007 and later) here: Setting a VBA Variable from a Bookmark.

Author Bio

Allen Wyatt

With more than 50 non-fiction books and numerous magazine articles to his credit, Allen Wyatt is an internationally recognized author. He is president of Sharon Parq Associates, a computer and publishing services company. ...

MORE FROM ALLEN

Creating a Split Page

In WordPerfect terminology, a split page allows you to put information side-by-side on opposite halves of the page. If ...

Discover More

Relative References to Cells in Other Workbooks

When you construct a formula and click on a cell in a different workbook, an absolute reference to that cell is placed in ...

Discover More

Inserting a Cross-Reference to Text

Cross-referencing is a great feature of Word that allows you to add references to text in various places of your ...

Discover More

Do More in Less Time! An easy-to-understand guide to the more advanced features available in the Microsoft 365 version of Word. Enhance the quality of your documents and boost productivity in any field with this in-depth resource. Complete your Word-related tasks more efficiently as you unlock lesser-known tools and learn to quickly access the features you need. Check out Microsoft 365 Word For Professionals For Dummies today!

More WordTips (menu)

Creating a String

Need to use a macro to create a text string? One easy way to do it is to use the String function, described in this tip.

Discover More

Swapping Two Strings

Part of developing macros is learning how to use and manipulate variables. This tip examines a technique you can use to ...

Discover More

Controlling the Bold Text Attribute

When processing a document in a macro, you may need to make some of your text bold. It's easy to do using the Bold ...

Discover More
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

View most recent newsletter.

Comments

If you would like to add an image to your comment (not an avatar, but an image to help in making the point of your comment), include the characters [{fig}] (all 7 characters, in the sequence shown) in your comment text. You’ll be prompted to upload your image when you submit the comment. Maximum image size is 6Mpixels. Images larger than 600px wide or 1000px tall will be reduced. Up to three images may be included in a comment. All images are subject to review. Commenting privileges may be curtailed if inappropriate images are posted.

What is seven more than 1?

2020-10-07 06:36:30

Stanley Sendek

Dear Mr Wyatt

I would like to ask how to associate the command button to fill-in fields (bookmarks) in a word file. Let us say I have a docx file with fill-in fields (updated and filled in through popup windows through CTRL+F9 like in this video https://www.youtube.com/watch?v=4ZBUN9oH7Tg) and I would like to fill them all at once through a click on a command button. I inserted a simple command button and put in the VBA code:

Private Sub CommandButton1_Click()
ActiveDocument.FormFields(xxxxx).Result = InputBox(xxx)
End Sub

But it does not work because I have not associated the button with the fill-in bookmarks..Thanks for your suggestions.
Stanley


2017-10-21 23:15:08

Ango

is it possible to insert text from a bookmark in a closed word file into a new word doc via excel vba - the bookmark names are in an excel list - can anyone help?


2015-05-01 12:21:49

Hannah

Currently I have language that generates a second page if needed based on a selection but I need to add a bookmark to the second page. How do I add a bookmark to the second page when it doesn't show up unless it needs to show up.


2015-04-29 06:14:43

Jaume Estrany Mas

How do I capture the value of a form field drop-down list in Word?
I used "Msgbox (ActiveDocument.Bookmarks (" list "). Range.Text" and not working.
If it is a text form field if it works.
Greetings, Jaume


2015-04-02 11:39:31

DonnaS

Hello, I am working on a project in Word 2013. Here's my last item. I have a drop-down list that allows for a search of a city. Once chosen, a second drop-down list is populated. The user picks from this list and now has two items chosen. For instance: City, Venue. I have this part complete and working.

Once we have a city and a venue I want the bottom part of the Word doc to fill with the details of that Venue. I have those stored and could make each a bookmark tied to the Venue? Or?

I'm stumped how to do this. I'm thinking bookmarks, but the second drop-down is a bookmark entitled ddVenue and because the value is always changing it doesn't seem possible. I'm open to QuickParts too. Or? It needs to happen automatically without user involvement.

I'm thinking it will probably need to be some type of VBA code that makes the bookmark variable, but I'm not certain how to do this. VBA is my weakness. Any thoughts? Direction?

Thank you!
Donna


2015-03-16 07:07:59

Ken Endacott

If you also want the text within each bookmark:

Sub TypeBookmarks()
Dim BookmarkName() As String
Dim aBookmark As Bookmark
Dim k As Long
Dim ignoreCode As String
ignoreCode = "" ' change to "-" to hide hidden bookmarks
ReDim BookmarkName(0)
k = 1
For Each aBookmark In ActiveDocument.Bookmarks
If Left(aBookmark.Name, 1) <> ignoreCode Then
ReDim Preserve BookmarkName(k)
BookmarkName(k) = "Name:" & aBookmark.Name & " Text:" & aBookmark.Range.Text
k = k + 1
End If
Next aBookmark

Selection.EndKey Unit:=wdStory
For k = 0 To UBound(BookmarkName)
Selection.TypeText vbCrLf & BookmarkName(k)
Next k
End Sub


2015-03-16 06:58:11

Ken Endacott

Sub TypeBookmarks()
Dim BookmarkName() As String
Dim aBookmark As Bookmark
Dim k As Long
Dim ignoreCode As String
ignoreCode = "" ' change to "-" to hide hidden bookmarks
ReDim BookmarkName(0)
k = 1
For Each aBookmark In ActiveDocument.Bookmarks
If Left(aBookmark.Name, 1) <> ignoreCode Then
ReDim Preserve BookmarkName(k)
BookmarkName(k) = aBookmark.Name
k = k + 1
End If
Next aBookmark

Selection.EndKey Unit:=wdStory
For k = 0 To UBound(BookmarkName)
Selection.TypeText vbCrLf & BookmarkName(k)
Next k
End Sub


2015-03-16 02:03:59

Johannes van der Zwan

Good day
I would like to see a macro that creates a sorted array of all the bookmarks and insert the array at the end of my document.

In the hope you can help me with this.
Thank you very much.
Johannes


This Site

Got a version of Word that uses the menu interface (Word 97, Word 2000, Word 2002, or Word 2003)? This site is for you! If you use a later version of Word, visit our WordTips site focusing on the ribbon interface.

Videos
Subscribe

FREE SERVICE: Get tips like this every week in WordTips, a free productivity newsletter. Enter your address and click "Subscribe."

(Your e-mail address is not shared with anyone, ever.)

View the most recent newsletter.