Originally Posted by Gizzmo

Ok Art,

I have added code to resize comment box.

Also to view code use Alt+F11 select ThisWorbook, Workbook and SheetChange.

PS if you search www.Ozgrid.com and have a look at some of the code that contributors have post such as Andy Pope OzMVP(Roobarb) and many others you will find a way to almost do anything in Excel. I new nothing about excel 14 years ago and today I am always learning thanks to people like you and Andy Pope.

Enjoy.