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