Tagging a Cell

  • Thread starter Syed Zeeshan Haider
  • Start date
S

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,
 
R

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.
 
D

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.
 
D

Dave Peterson

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

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