Dynamic "Comment"
 

Got the dynamic chart titles and the dynamic auto shapes to work. NOW is
there any easy way to make the comment box dynamic. User can click on that
cell and see where the numbers, data came from.. Either concatenate or just
show contents of a cell. Could cheat and have the concatenate in a hidden
cell.
May not be possible since have been trying for about an hour now.

Dynamic "Comment"
 

How would the comment be dynamic?

How would it know what to update and when?

In general, I'd use an extra cell for this kind of stuff. You'll be able to use
all the stuff you can use with data stored in a worksheet cell--sort, filter...

John McCabe wrote:

Got the dynamic chart titles and the dynamic auto shapes to work. NOW is
there any easy way to make the comment box dynamic. User can click on that
cell and see where the numbers, data came from.. Either concatenate or just
show contents of a cell. Could cheat and have the concatenate in a hidden
cell.
May not be possible since have been trying for about an hour now.

--

Dave Peterson