Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" with ce
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" with ce
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" wrote in message ... 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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" wit
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" wrote: 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" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" with ce
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 tbd wrote: 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! -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property I can use to store "stuff" wit
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!!! "Dave Peterson" wrote: 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 tbd wrote: 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! -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property, FOLLOW UP
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" wrote: 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 tbd wrote: 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! -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Do cells have a string-property, FOLLOW UP
Thanks for posting back.
Maybe you can use that hidden worksheet idea. tbd wrote: 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" wrote: 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 tbd wrote: 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! -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA code store address with areas separated with "," and I need it sometimes with ";" instead | Excel Programming | |||
Multiple "Range" with "Cells" property? | Excel Programming | |||
Multiple "Range" with "Cells" property? | Excel Programming | |||
Allocating "Don't Move or size with cells" property in code | Excel Programming |