VB Code to size the comment box
 

After using :- Cells(1,1).Comment.Text Text:=discription$

where discription$="abcdefghijklmnopqrstuvwzyz"

Who do i resiz the comment box using code, such that the box will show the
complete comment.

I have tried to record a macro but this does not work.

Thanks
Sunil

VB Code to size the comment box
 

Look here

http://www.contextures.com/xlcomments03.html#Resize
(From Debra Dalgeish's site)

--
Regards Ron de Bruin
http://www.rondebruin.nl


"SUNIL PATEL" wrote in message ...
After using :- Cells(1,1).Comment.Text Text:=discription$

where discription$="abcdefghijklmnopqrstuvwzyz"

Who do i resiz the comment box using code, such that the box will show the
complete comment.

I have tried to record a macro but this does not work.

Thanks
Sunil