| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
textsize on comments
I want to make the textsize in a comment bigger , but I
can't find any vba code to do this. If it isn't possible to change the fontsize of a comment in a macro, is there someway to change the default font and size of a comment's text? /Andreas |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
textsize on comments
Its a bit of a long one this...!
ActiveCell.Comment.Shape.TextFrame.Characters.Font .Size = 16 Cheers, Dave. -----Original Message----- I want to make the textsize in a comment bigger , but I can't find any vba code to do this. If it isn't possible to change the fontsize of a comment in a macro, is there someway to change the default font and size of a comment's text? /Andreas . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
textsize on comments
Big thanks!
/Andreas -----Original Message----- Its a bit of a long one this...! ActiveCell.Comment.Shape.TextFrame.Characters.Fon t.Size = 16 Cheers, Dave. -----Original Message----- I want to make the textsize in a comment bigger , but I can't find any vba code to do this. If it isn't possible to change the fontsize of a comment in a macro, is there someway to change the default font and size of a comment's text? /Andreas . . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comments | Excel Worksheet Functions | |||
| excel 2000 how to format the comments font all comments | Excel Discussion (Misc queries) | |||
| in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
| Comments | Excel Discussion (Misc queries) | |||
| comments | Excel Programming | |||
![Andreas[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
