Silently Mark Tables and Cells

[Asin]

I want to mark some cells with a tag that isn't displayed to the user.
Something like the ID attribute in an HTML tag.

However, when I try to use Selection.Range.Cells(1).ID = "something", the ID
doesn't persist between document sessions. That is, when I close and reopen
the document, even with a save, it is no longer set. This is evidenced with
another macro which has the following code:

MsgBox (Selection.Range.Cells(1).ID)

Any help with this is greatly appreciated.

 

[Doug Robbins - Word MVP]

Tell us the purpose of the marking and we may be able to suggest another way
of achieving the same thing.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Jean-Guy Marcil]

I want to mark some cells with a tag that isn't displayed to the user.
Something like the ID attribute in an HTML tag.

However, when I try to use Selection.Range.Cells(1).ID = "something", the ID
doesn't persist between document sessions. That is, when I close and reopen
the document, even with a save, it is no longer set. This is evidenced with
another macro which has the following code:

MsgBox (Selection.Range.Cells(1).ID)

The ID property (as stated in the VBA help - which you should install) for
tables and cells is provided for documents that are saved as Web pages (HTML).

I guess you could use bookmarks.

But, as Doug wrote, if you tell us your purpose, you might get a more useful
reply.

 

[Henry Kwan]

We have these test plans (in a Quality Assurance department) that I'm trying
to fix up and standardize the Pass/Fail procedure. Currently, it's a
free-for-all (to a degree) in terms of how you mark them off.

Recently, we've also been gathering statistics on the pass/fail rate and
gathering bug numbers and their descriptions.

In addition, some test cases are skipped for whatever reason. I would like
to mark them all off so that I can have a proper total number of test cases
and calculate some pass/fail percentages as a result.

I've spoken to some people in the office and they've suggested that I make
use of a "Pass/Fail" column heading which is more or less part of the
standard. There are a few exceptions in some cases.

If I wish to force the user to enter some data, but not necessarily display
it for the test case. It would be nice to be able to save that somewhere
until the test plan is complete and the Calculate Statistics macro is
initiated. An example would be priority which would be nice in table form,
but probably unnecessary to have beside each failed test case.

 

[Doug Robbins - Word MVP]

I would suggest that you should be using some kind of form. See the
following page of fellow MVP Dian Chapman's website:

http://www.mousetrax.com/techpage.html#autoforms


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP