Tagging a Cell
 

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,
--
Syed Zeeshan Haider.
http://szh.20m.com/
http://gomusharrafgo.20m.com/

-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"

Tagging a Cell
 

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.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Syed Zeeshan Haider" wrote in
message ...
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,
--
Syed Zeeshan Haider.
http://szh.20m.com/
http://gomusharrafgo.20m.com/

-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"

Tagging a Cell
 

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 wrote:

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.

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Syed Zeeshan Haider" wrote in
message ...
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,
--
Syed Zeeshan Haider.
http://szh.20m.com/
http://gomusharrafgo.20m.com/

-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"



--

Dave Peterson

Tagging a Cell
 

I'm running Excel 2000.

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

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Dave Peterson" wrote in message
...
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 wrote:

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.

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Syed Zeeshan Haider" wrote in
message ...
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,
--
Syed Zeeshan Haider.
http://szh.20m.com/
http://gomusharrafgo.20m.com/

-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"



--

Dave Peterson

Tagging a Cell
 

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

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

Rob van Gelder wrote:

I'm running Excel 2000.

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

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Dave Peterson" wrote in message
...
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 wrote:

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.

--
Rob van Gelder - http://www.vangelder.co.nz/excel

"Syed Zeeshan Haider" wrote in
message ...
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,
--
Syed Zeeshan Haider.
http://szh.20m.com/
http://gomusharrafgo.20m.com/

-----------------------------------
Allah says to Mankind:
"Then which of the favours of your Lord will ye deny?"



--

Dave Peterson


--

Dave Peterson