| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatically calculate in a cell comment
Hi all,
Is it possible to have a calculation that calculates a figure and then have the answer appear in the cell's comment field. Thanx in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatically calculate in a cell comment
It would be a lot simpler and would be updated properly
if you simply used another column than using a macro. This is the programming group so I guess you really do want a programming solution. I would still suggest using another column and something more oriented to your actual goal, which I can only guess at. Read about Event Macros http://www.mvps.org/dmcritchie/excel/event.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Maddoktor" wrote in message ... Hi all, Is it possible to have a calculation that calculates a figure and then have the answer appear in the cell's comment field. Thanx in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I calculate the z factor automatically | New Users to Excel | |||
| calculate the z factor automatically | New Users to Excel | |||
| How do I calculate the z factor automatically | Charts and Charting in Excel | |||
| copy comment content to cell content as data not as comment | Excel Discussion (Misc queries) | |||
| how can i automatically insert cell values into a comment field? | Excel Discussion (Misc queries) | |||
Linear Mode
