Tagging a Cell

[Syed Zeeshan Haider]

Hello Experts,
I have Excel 97 Pro on Win98SE.

Is there anyway of tagging a cell for VB to recognize it? I want this
tagging work like the Tag Property of VB controls.

Thank you,

 

[Rob van Gelder]

A few of ways that I know how:

Give the cell a unique form of formatting.
Use the Range.ID property (this is not really for Tagging purposes but
should work)

I also believe there is a way using Input messages of Data Validation,
though I've never tried it.

 

[Dave Peterson]

IIRC, that range.id was added after xl97. (It's in xl2002--I don't think it's
in xl2k--but that's a guess!)

And if you save/close that workbook, that .id property is lost.

Maybe keeping the info in a hidden sheet or a hidden worksheet name would work
for the OP.

 

[Rob van Gelder]

I'm running Excel 2000.

You're right!
ID is lost after the workbook closes.

 

[Dave Peterson]

And thanks for your correction (that it was added in xl2k).

(It might sink in if I hear it enough!)