LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default 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






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I copy cell attributes between worksheets charlesm Excel Discussion (Misc queries) 1 May 22nd 08 04:19 AM
Cell attributes John.Tucker[_2_] Excel Discussion (Misc queries) 3 April 27th 07 09:34 AM
Data value display attributes linked to table attributes MDT at Paragon Home Inspections, LLC Charts and Charting in Excel 0 November 15th 06 12:53 AM
store inventory sheet(ex:sports equipment store) vardan Excel Worksheet Functions 1 October 11th 06 12:51 AM
Attributes of a cell Robbie[_5_] Excel Programming 1 October 22nd 03 12:59 PM


All times are GMT +1. The time now is 10:19 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"