Sub UpdateComment - is the length restrictions

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

objComment.Shape.TextFrame.Characters.Text = Text

to this:

objComment.Text Text

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

Tested once and works

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

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

...Comment.Shape.TextFrame.AutoSize = True

2) Increment size every time with multiply actual size:

...Comment.Shape.ScaleWidth 1.1, msoFalse, msoScaleFromTopLeft
...Comment.Shape.ScaleHeight 1.04, msoFalse, msoScaleFromTopLeft

3) Increment with static value:

...Comment.Shape.Height = .Comment.Shape.Height + 10
...Comment.Shape.Width = .Comment.Shape.Width+ 10

Hope it helps