Change Default Comment Box Size

**stevedes7** · 10-14-2009, 02:31 PM

Pretty self explanatory.

I need to default size to be bigger. Is there a way to do this so I do not need to re-size the box every time?

**Palmetto** · 10-15-2009, 07:55 PM

You will have to use a VBA solution. Excel does not provide a means to change the default size.

Adapt this code as desired. Also include is code to align the comments. Delete these lines if you don't want this.

Open the VB Editor and copy this into a standard module, then run it when desired.

Please Login or Register  to view this content.

**stevedes7** · 10-17-2009, 11:09 PM

As always, thanks so much Palmetto.

**Sam2149** · 02-21-2014, 03:53 PM

Hi I have just stumbled on this post and I would like to make this work but I know very little about VBA

I think I have got it to work now.

As a second question is it possible the use the above VBA to set the default font style and font size

Regards

**Sam Capricci** · 02-21-2014, 11:13 PM

Sam2149, welcome to the forum. Take time to acquaint yourself with the forum rules under the forum rules link at the top.
as such you'll see that your post violates rule #2.
Don't post a question in the thread of another member -- start your own. If you feel it's particularly relevant, provide a link to the other thread. You may include up to 3 links to other URLs in a single post, no more, so only link to the relevant pages.

So the best thing to do is start your own post.