Thread: VB Code to size the comment box
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
  
Posts: 11,123
Default 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




Reply With QuoteReply With Quote