| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert cell "contents" into a "comment" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Linear Mode
