Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to store additional attributes for a cell
Hi all,
I'm looking for a possibility to store some additional attributes for the cells in my sheet. My VBA script needs some data for later decission making. The additional data should not be displayed for to the user. Does a Cell object has a property which I can use for that purpose? Thanks a lot, Thorsten |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to store additional attributes for a cell
Hi Thorsten
The only one I can think of is the ID property Sub test() Sheets(1).Cells(2, 3).ID = "Harald's cell" MsgBox Sheets(1).Cells(2, 3).ID End Sub But it doesn't save between sessions, so it's useless for storage. Id' rather write to corresponding cells in a hidden sheet, given that "should not be displayed" means only that and not that the information is top secret. HTH. Best wishes Harald "Thorsten Walenzyk" skrev i melding ... Hi all, I'm looking for a possibility to store some additional attributes for the cells in my sheet. My VBA script needs some data for later decission making. The additional data should not be displayed for to the user. Does a Cell object has a property which I can use for that purpose? Thanks a lot, Thorsten |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to store additional attributes for a cell
Why not think about store your additional data as a comment in the cell
"Thorsten Walenzyk" wrote in message ... Hi all, I'm looking for a possibility to store some additional attributes for the cells in my sheet. My VBA script needs some data for later decission making. The additional data should not be displayed for to the user. Does a Cell object has a property which I can use for that purpose? Thanks a lot, Thorsten |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to store additional attributes for a cell
The data is definetly not top sectret and must not be stored persistently.
So this sounds sufficient for me. Thanks Thorsten "Harald Staff" wrote in message ... Hi Thorsten The only one I can think of is the ID property Sub test() Sheets(1).Cells(2, 3).ID = "Harald's cell" MsgBox Sheets(1).Cells(2, 3).ID End Sub But it doesn't save between sessions, so it's useless for storage. Id' rather write to corresponding cells in a hidden sheet, given that "should not be displayed" means only that and not that the information is top secret. HTH. Best wishes Harald "Thorsten Walenzyk" skrev i melding ... Hi all, I'm looking for a possibility to store some additional attributes for the cells in my sheet. My VBA script needs some data for later decission making. The additional data should not be displayed for to the user. Does a Cell object has a property which I can use for that purpose? Thanks a lot, Thorsten |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to store additional attributes for a cell
Just to mention. If you save your workbook as a Web page (.htm format),
then the .ID property does gets saved with the cell. -- Dana DeLouis Win XP & Office 2003 "Thorsten Walenzyk" wrote in message ... The data is definetly not top sectret and must not be stored persistently. So this sounds sufficient for me. Thanks Thorsten "Harald Staff" wrote in message ... Hi Thorsten The only one I can think of is the ID property Sub test() Sheets(1).Cells(2, 3).ID = "Harald's cell" MsgBox Sheets(1).Cells(2, 3).ID End Sub But it doesn't save between sessions, so it's useless for storage. Id' rather write to corresponding cells in a hidden sheet, given that "should not be displayed" means only that and not that the information is top secret. HTH. Best wishes Harald "Thorsten Walenzyk" skrev i melding ... Hi all, I'm looking for a possibility to store some additional attributes for the cells in my sheet. My VBA script needs some data for later decission making. The additional data should not be displayed for to the user. Does a Cell object has a property which I can use for that purpose? Thanks a lot, Thorsten |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to store additional attributes for a cell
The data is definetly not top sectret and must not be stored persistently.
So this sounds sufficient for me. Thanks to Harald ... I need to store different data and I guess, this is the only property I can (mis-) use. I tried something like this: Public Type MyType somedata As Integer someother As String End Type Private Sub test() Dim CellData As MyType CellData.somedata = 42 CellData.someother = "fourty-two" Sheets(1).Cells(2, 2).ID = CellData End Sub But I've got the error: "Only user-defined types defined in public object modules can be coerced to or from a variant or passed to late-bound functions" As I have defined MyType as a Public type, I guess the problem is the "public object module". What is a "public object module" and how can I create one ??? Thanks a lot, Thorsten |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I copy cell attributes between worksheets | Excel Discussion (Misc queries) | |||
Cell attributes | Excel Discussion (Misc queries) | |||
Data value display attributes linked to table attributes | Charts and Charting in Excel | |||
store inventory sheet(ex:sports equipment store) | Excel Worksheet Functions | |||
Attributes of a cell | Excel Programming |