|Subject:||Re: Comment value from cell content|
|Posted by:||Creamegg (colinbainbridg…@googlemail.com)|
|Date:||Thu, 17 Jul 2008|
Thanks for your help. It's just what I needed.
On Jul 17, 6:23 pm, "Rick Rothstein \(MVP - VB\)"
> You can do what you want using the worksheet's Change event. Give this a
> try... right-click the tab for the worksheet with the cell whose value you
> want to incorporate in the comment (this is not the cell where the comment
> will be placed; rather, the cell whose value you want to retrieve), click on
> View Code from the popup menu that appears and copy/paste the following in
> the code window that appeared...
> Private Sub Worksheet_Change(ByVal Target As Range)
> If Target.Address = "$B$1" Then
> With Worksheets("Sheet1").Range("A1")
> .AddComment "Cell B1 now contains " & Target.Value
> End With
> End If
> End Sub
> For example purposes, the above code assumes the cell whose value you want
> to monitor (and whose value you want to display in the comment) is B1 and
> the cell where the comment will be placed is A1.
> Now, whenever you change B1 on that worksheet, the comment in A1 will change
> to show the new value in B1 as part of its text.
> "Creamegg" <colinbainbrid.…@googlemail.com> wrote in message
> >I would like to populate a comment with a value taken from a different
> > cell. Is there a simple way to reference a cell within a comment?
> > I am a fairly basic user with very limited knowledge of Visual Basic.
Re: Comment value from cell content posted by Rick Rothstein \(MVP - VB\) on Thu, 17 Jul 2008