Thread: Comment boxes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz[_2_] JLGWhiz[_2_] is offline
external usenet poster
 
Posts: 1,565
Default Comment boxes

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