| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading Comment Formats
Is there any way to programmatically recognize individual character formats
in a comment for superscript, subscript, or double underline? ActiveCell.Comment.Shape.TextFrame.Characters(i, 1).Font.Superscript and ActiveCell.Comment.Shape.TextFrame.Characters(i, 1).Font.Subscript both exist, but do not appear to be maintained by Excel, since they are always Null. ActiveCell.Comment.Shape.TextFrame.Characters(i, 1).Font.Underline is maintained by Excel, but as a Boolean (which therefore ignores double underline), unlike ActiveCell.Comment.Shape.TextFrame.Characters.Font .Underline which contains values like xlUnderlineStyleNone, xlUnderlineStyleSingle, and xlUnderlineStyleDouble Jerry |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| No ActiveX controls when reading 2007 file formats into Excel 2003 | Excel Discussion (Misc queries) | |||
| Set Comment formats 'globally'? | Excel Discussion (Misc queries) | |||
| pivot table not reading date formats | Excel Worksheet Functions | |||
| 2 Conditional formats and insert comment - ajit | Excel Discussion (Misc queries) | |||
| Reading Date Formats e.g 20050801 (yyyy/mm/dd) | Excel Discussion (Misc queries) | |||
Threaded Mode
