• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 437
  • Last Modified:

Excel VBA storing additional information attached to a cell

Hi

Is there a way to store additional information behind an Excel cell using Excel VBA.
In other words additional notes that are not in the cell value and not in the notes
0
Murray Brown
Asked:
Murray Brown
  • 2
1 Solution
 
gowflowCommented:
give me an example. You say VBA well you can use in VBA this info and when you click on the cell it will show it to you as a msgbox like the attached file click on any cell in sheet1 then click on cell C5

Let me know if this is what you want.
gowflow
msg.xls
0
 
redmondbCommented:
Hi, murbro.

The attached has two separate approaches (described below). The first is interesting, but I think that the the second is more workable!

(1) Using Excel Hidden Data Store.

In Sheet1, please double-click on any of the yellow cells to display a message showing the cell's additional information.

The file uses a little known feature of Excel which allows you to store information for the current session (or until cleared) - please see this article.

(2) Using a Hidden Sheet.

In Sheet2, please double-click on any of the green cells to display a message showing the cell's additional information.

Regards,
Brian.Extra-Info.xls
0
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
 
redmondbCommented:
Thanks, murbro.
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.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now