Sub UpdateComment - is the length restrictions

[waihar]

Hi All ,

I have attached a file here , i previously posted get ideas to update comment via Userform

Andy Pope has kindly suggested a great ideas.

http://www.excelforum.com/excel-prog...n-comment.html

I have added the function and it works great .

Until lately users wanted to add comment as long as a paragraph , and it did not work any more .
So was curious if anyone knows its its a length restrictions , and how its possible to add longer comment .

I have tried text as length below @ 143 char (it did not work)
One Two Three Four Five Six Seven Eight Nine Ten Evelen Twelve Thirteen Fourteen Fifteen Sixteen Seventeen Eighteen Nineteen Twenty TwentyOne

I get the results printed until Sixteen. @ 97 Character.

Any idea i can update longer comment ?

Any suggestion is very much appreciated.
Thanks very much in advance to all

Cheers ,
waihar

[Miroslav R.]

Hi there,
did not look deeper, but try to change this bit of Your code:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

'placed in Private Sub UpdateComment(InCell As Range, Text As String)'

Tested once and works

[waihar]

thanks , it works great.

Just one more questions , do you happens to know how can the comment box can auto expend to display the full comment .
when cursor move to that place ?
Currently i have to manually expend the message to see the full ones when user enter it very long.

Cheers , waihar

[waihar]

Its ok , i got the answer to my above question of auto expand comment box in below link

http://www.excelforum.com/excel-prog...too-small.html

But this above expand vertically , and quite difficult to read ,
any method to have it expand horizontally too , any suggestion ??

thanks in advance.
cheers ,
waihar

[Miroslav R.]

Hi there,
Without searching, I know only 3methods how to work with comment size:
1) Yours 'Autosize', which You already tested

Please Login or Register  to view this content.

2) Increment size every time with multiply actual size:

Please Login or Register  to view this content.

3) Increment with static value:

Please Login or Register  to view this content.

Hope it helps