PC Review


Reply
Thread Tools Rate Thread

Comment boxes

 
 
Anthony
Guest
Posts: n/a
 
      16th Aug 2009
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


 
Reply With Quote
 
 
 
 
JLGWhiz
Guest
Posts: n/a
 
      16th Aug 2009
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
>



 
Reply With Quote
 
Anthony
Guest
Posts: n/a
 
      16th Aug 2009
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
>>

>
>



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
comment boxes =?Utf-8?B?dy1kb21v?= Microsoft Excel Misc 1 21st Jan 2005 01:30 PM
comment boxes =?Utf-8?B?dGpl?= Microsoft Excel Misc 1 7th Apr 2004 03:22 PM
Comment Boxes John M Microsoft Excel Programming 3 13th Nov 2003 04:02 AM
Re: comment boxes David McRitchie Microsoft Excel Worksheet Functions 0 25th Jul 2003 09:53 AM
Re: Comment boxes Bob Phillips Microsoft Excel Misc 0 8th Jul 2003 09:55 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:36 PM.