counting comments in a cell and...

Microsoft Office access 2007 (full produ...
July 6, 2010 at 04:32:18
Specs: Windows XP
Hi all,
I have a large number of cells (I have made a calendar) and I have a different number of comments throughout the sheet, heres what I want to do:

My cells with comments in them run from B:2 to BB:78, I want a code that will go through all of these cells, count how many comments are in each and post that number to the cell.

Example: If C:9 has two comments in it, I want the code to run through all of the cells, and post '2' in cell C9 as well as all other cells.


See More: counting comments in a cell and...

July 6, 2010 at 05:30:37

Since I provided the macros (via email) that put the comments in the cells, I'm probably the only one that can answer that question.

re: count how many comments are in each cell

That's easy: The answer is 1.

You can only have 1 comment per cell.

However, you can (and sometimes do) have multiples lines in each comment. As you know from the last workbook I sent you, the code either adds a Comment to a cell or "edits" the existing Comment and adds additional lines.

In order to put the number of "comment lines" in the cell related to a given comment, the code will need to be modified to either increment a number in the respective cell whenever a comment is added/edited or actually count the lines in each comment. I think the former would be easier, but it won't be accurate if you manually edit a comment to add or delete lines.

Since I don't have the code with me at work, I can't give you any answers until this evening, at the earliest.

Report •

July 6, 2010 at 05:38:51
As helpful as ever. I know exactly what you mean regarding the comment number, can't believe I didn't think of it before - so yes, the number of lines would be the next logical step...

Any help you could give, as always, would b greatly appreciated.

Best regards.

Report •
Related Solutions

Ask Question