VB.net Excel Add-in Second value or tag for a cell

Hi
I need to put some hidden information behind a cell, like a tag of sorts
I used the following but that just updated the actual cell value

 Globals.ThisAddIn.Application.ActiveCell.Value2 = oResult
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
aikimarkCommented:
I would agree with Zack's assessment that a hidden worksheet might be the easiest implementation.

===============
Alternatively, you can use the cell's .ID property
Example:
Activecell.ID = "Now is the time for all good men"

Open in new window


===============
If it were feasible, you could disable visible notes (an option) and assign the .NoteText property of a cell.  The text is there, but the user wouldn't see the triangle indicator and the fly-out textbox wouldn't appear.

You might also do this with the .Comment property.

===============
You might also use the custom document properties (.CustomDocumentProperties) of the workbook to store data.  You would probably include the cell address followed by the text.
0
 
Zack BarresseCEOCommented:
Unfortunately there is no such thing as meta data for cells. You could store information in your application settings. Or create a temporary, hidden sheet to store your data. Or even write it to a text or config file.
0
 
aikimarkCommented:
What type of data do you need to associate with a cell?
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
I just want to associate text data
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Great answer. Exactly what I needed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.