Comment boxes
 

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

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

Comment boxes
 

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