Autocomments to display cell history

I am trying to find a way to automatically add comments to specific cells. I want to be able to create a cell history. For example:

Say I have the number "5" entered in cell A2 and the word "vase" in cell B2. If I then enter the number "3" in cell A2 and the word "bowl" in cell B2 I want it to automatically add the original number "5" and word "vase" in a comments box for cell A2 that appears when you hover the cursor over the cell.

Is this at all possible? If so does anyone have a code suggestion?

Any help would be much appreciated.

Thanks

Does anybody have any ideas to this question? Even if it's just to let me know that it is possible or not.

Any help would be great.

Thanks tigeravatar

Is there a way to link multiple cells into just one comment box rather than have them pop up for each individual cell.

e.g. A1 & B1 cell contents merge into A1 comment box only

Thanks

My spreadsheet basically works in two column pairs. So cells B and C are linked, E and F, G and H, J and K, L and M, O and P, R and S, U and V, W and X, Z and AA, AB and AC and AE and AF.

There are 50 rows used in each column.

So B2 and C2 should merge, B3 and C3 and so on going down the rows. Then E2 and F2, G2 and H2 etc continuing across the columns and down their respective rows.

Hope that all makes sense.

Thanks

Tigeravatar,

Thank you very much for all your help. It works perfectly.

Until the next excel question...

Thanks

No. I want it to alternate depending on the specific column. At the moment it is BC, EF, GH, JK etc. I want it to be BC, FE, GH, KJ.

Sorry about the private message - as the post was marked as solved I was not sure if you would be able to read it. My apologies.

The comments for BC, GH, LM etc are working fine. However the comments are now becoming seperated when it comes to columns FE, KJ, PO etc. So it reads F and the value, E and the value rather than the two combined in F.

Hope that makes sense.

Thanks

The comments for FE, KJ, PO etc are now working fine. However the comments in BC, GH, LM etc are now becoming seperated. So it reads B and the value, C and the value rather than the two combined in B.

Hope that makes sense.

So what we have is the code from post 12 working the right way for BC, GH, LM etc and the code from post 14 working the right way for FE, KJ, PO etc. Now just need to combine the two.

Thanks for your continued help.

Works! Thats perfect.

Thanks very much for all of your help.