Thank you. The size of the comments will be small.

It should be fine with what I have planned

Regards


Anthony

"JLGWhiz" wrote in message
...
The number of comments is limited by your system resources, but the amount
of data within the comment is liimited. I am not sure what that limit is.


"Anthony" wrote in message
...
Hi,

Is there a limit to the number of comment boxes a worksheet / work book
can have.

I need to display some information against certain lines of data and the
easiest way is to use a comments box.

There could be a max of 1000 comment boxes need on a single sheet and
there are 2 sheets.

So 2000 in the whole workbook would be the maximum, bt they are only
added if criteria is met.


Regards


Anthony

p.s office 07 in compatibility mode 03