Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


MS Word, VB6 and VBA: How set a custom flag/object/property/tag to a Range object?

Posted on 2015-01-09
Medium Priority
Last Modified: 2015-01-25
Is there a way to assign a user defined something like flag/object/property/tag to a Range object?
Does the Range object has some unused property of Variant/String/Object type which the user could use for its on purpose?

In VB6 for instance, controls have the Tag (string) property, which is not used by VB6 by default, and it can be used for any purpose, such as assigning some data to that control.

So, is there some equivalent for the Range object?
Question by:npaun
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
LVL 18

Expert Comment

ID: 40539982
I'd think not. A control is a persistent object whose properties can be written to file, whereas a range is an ephemeral one.
LVL 15

Accepted Solution

DrTribos earned 1500 total points
ID: 40539993
I think you might have to look at bookmarks or content controls
LVL 18

Expert Comment

ID: 40540112
For Word there are custom document properties that you can create/edit/delete.
For Excel there is the names collection and cells can be assigned an ID:
"Returns or sets a String value that represents the identifying label for the specified cell when the page is saved as a Web page."

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.


Author Comment

ID: 40540121
You mean CustomDocumentProperties? If I understated correctly, they are document level properties, while I need it for Range object (e.g. selections, Words...)
LVL 18

Expert Comment

ID: 40540159
There is the range.comment object which is part of the tracked changes/review document process.

Selection.Comments.Add Range:=Selection.Range

This creates a review comment that is associated with the range (word, phrase, paragraph) that you want.

You can then do various things with the comment and/or the range it refers to.

Sub test()
Dim myRange As Range
If ActiveDocument.Comments.Count >= 1 Then
    For x = 1 To ActiveDocument.Comments.Count
    Set myRange = ActiveDocument.Comments(x).Range
    Debug.Print myRange, myRange.Start, myRange.End
    Next x
End If
End Sub

Author Comment

ID: 40540221
Thanks for the reply. Yes, I know for the comment property, however it has internal use by Word, and all entries here would be seen in the user comments selection, i.e. these entries would interfere with comments manually and explicitly added by the user itself... I would need a Range property that is "unused" and would not so easily interfere with Word...

Author Comment

ID: 40540240
Thank for the post.
Unfortunately, the ContentControls also severely interfere with the Word normal behavior, it, as intended, ads clearly visible controls in the text...
LVL 15

Expert Comment

ID: 40540873
Yup, aside from that i think it is bookmarks.

Other approaches that I can think of would be very 'hacky'...

1. Delineate range via a portfolio of uniquely named styles all with the same appearance
2. Delineate using table cell
3. Delineate using field codes

But as far as I know bookmarks is the go

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A few years ago I was very much a beginner at VBA, and that very much remains the case today.  I'll do my best to explain things as I go in the hope that other beginners can follow.  If you just want to check out a tool that creates a Select Case fu…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
This video walks the viewer through the process of creating a watermark for their document, customizing it, and saving it for viewing/printing needs.
This video walks the viewer through the process of creating an MLA formatted document, as well as a bibliography with citations.
Suggested Courses

609 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