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

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" <anthony-(E-Mail Removed)> wrote in message
news:h67jrf$pcp$(E-Mail Removed)...
> 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
>

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

It should be fine with what I have planned

Regards


Anthony

"JLGWhiz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <anthony-(E-Mail Removed)> wrote in message
> news:h67jrf$pcp$(E-Mail Removed)...
>> 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
>>
>
>