View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default format the cell Comment

try these or some variation

activecell.Comment.Shape.Width = 212
activecell.Comment.Shape.height = 25

--


Gary


"sid" wrote in message
...
Can I change the format of the comment in excel ?

I need it to be wider and shorter.

Thanks