Do cells have a string-property I can use to store "stuff" with ce

  • Thread starter Thread starter tbd
  • Start date Start date
T

tbd

Greetings,
Am currently seeking a way to store date,row,col info WITH each cell.
Q. Do cells have a user-defined (string) property?

This question grows out of a need to simplify associating a cell with
some other detail. For more detail, please see my previous post!

Thanks/Cheers!
 
Hi tbd,

You can add a comment to a cell, and you can make comments invisible, show an indicator to evidence their presence, or you can
display them.
 
Hi macropod,
Good suggestion! (however...) All the cells for which I need to store
"stuff" already have comments - text presented to the user on cell-select. I
haven't looked into whether one cell can have multiple comments; in that case
a second comment could serve my purpose. Will look into it - Thanks!

Cheers
macropod said:
Hi tbd,

You can add a comment to a cell, and you can make comments invisible, show an indicator to evidence their presence, or you can
display them.

--
Cheers
macropod
[Microsoft MVP - Word]


tbd said:
Greetings,
Am currently seeking a way to store date,row,col info WITH each cell.
Q. Do cells have a user-defined (string) property?

This question grows out of a need to simplify associating a cell with
some other detail. For more detail, please see my previous post!

Thanks/Cheers!
Click to expand...
Click to expand...
 
You could always use another cell (on a hidden worksheet???).

xl2002 (I think) added a property to the range object named .Id.

Depending on what you're doing, it may be useful. The .id property is used for
HTML stuff.

If you save as a normal excel workbook and close and reopen the workbook, then
your data in the .id property won't be there.

Option Explicit
Sub aaa()
Worksheets(1).Range("A1").ID = "hi there"
End Sub
Sub bbb()
MsgBox Worksheets(1).Range("A1").ID
End Sub
 
Hi Dave,
The range.cells(#,#).ID seems to work great! This sheet gets "painted"
every time the workbook is opened, IDs are assigned string-data during Paint
(or edit.)

I didn't bother to enclose the data in tags, but I'll remember ID is for
HTML and appreciate the background.

Perfect!!!
Thanks!!!
 
Just wanted to follow-up,
ID property seemed to be working until I upgraded to 2007(?)
In 2002 I wrote a value to ID once, and kept using it even as the cell was
changed.
With 2007, it seems, ID gets whipped-out whenever a new cell-value is written.

Oh well!
 
Thanks for posting back.

Maybe you can use that hidden worksheet idea.
Just wanted to follow-up,
ID property seemed to be working until I upgraded to 2007(?)
In 2002 I wrote a value to ID once, and kept using it even as the cell was
changed.
With 2007, it seems, ID gets whipped-out whenever a new cell-value is written.

Oh well!
--
The Cobra
[Footnote:] A few Cobras in your home will soon clear it of Rats and Mice.
Of course, you will still have the Cobras. (a quote by Will Cuppy
http://en.wikiquote.org/wiki/Will_Cuppy)

Dave Peterson said:
You could always use another cell (on a hidden worksheet???).

xl2002 (I think) added a property to the range object named .Id.

Depending on what you're doing, it may be useful. The .id property is used for
HTML stuff.

If you save as a normal excel workbook and close and reopen the workbook, then
your data in the .id property won't be there.

Option Explicit
Sub aaa()
Worksheets(1).Range("A1").ID = "hi there"
End Sub
Sub bbb()
MsgBox Worksheets(1).Range("A1").ID
End Sub
Click to expand...
Click to expand...
 
Back
Top