Solved My macro needs to resize the cell comment from Font 8 to 12

March 6, 2013 at 09:04:53
Specs: Windows 7
I am using Excel 2007 and have written a macro to create a worksheet that represents a timeline visually from a milestone list. I am adding comments to some cells, however they are set in Tahoma 8 which is too small.

I've tried recording a macro where i edit the cell and increase the size from 8 to 12, however the code merely records the text that I assigned to the Add.Comment, it doesn't impact the font size.

Is there a way to do this using macro code?


See More: My macro needs to resize the cell comment from Font 8 to 12

Report •


#1
March 6, 2013 at 11:21:59
✔ Best Answer

Report •

#2
March 7, 2013 at 01:24:16
I used the solution on Chandoo.org and it worked perfectly. Many thanks for your help ... the code is awesome.

Michael


Report •

Related Solutions


Ask Question