| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Format text using VBA
Is it possible to embolden part of the text held in a cell using VBA?
For example, if a cell contains two words " dog cat" is it possible to change the font of "dog" to bold without changing the attributes of "cat"? Alan |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format text using VBA
With ActiveCell
.Characters(5, 3).Font.Bold = True End With -- __________________________________ HTH Bob "Alan" wrote in message ... Is it possible to embolden part of the text held in a cell using VBA? For example, if a cell contains two words " dog cat" is it possible to change the font of "dog" to bold without changing the attributes of "cat"? Alan |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Format text using VBA
On 30 Apr, 09:57, "Bob Phillips" wrote:
* * With ActiveCell * * * * .Characters(5, 3).Font.Bold = True * * End With -- __________________________________ HTH Bob "Alan" wrote in message ... Is it possible to embolden part of the text held in a cell using VBA? For example, if a cell contains two words " dog cat" is it possible to change the font of "dog" to bold without changing the attributes of "cat"? Alan- Hide quoted text - - Show quoted text - Thanks Bob, that is a great help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need help with converting CUSTOM format/TEXT format to DATE format | Excel Worksheet Functions | |||
| Change Date Format to Specific Text Format When Copying | Excel Discussion (Misc queries) | |||
| how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
| how to format a Docmd to pull in an Access file in Text format | Excel Programming | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Linear Mode
