View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default Format Part of Text Cell using VBA

If the value in the cell is a number or the results of a formula, then you can't
do this kind of formatting.

But if the value in the cell is text, then
you can select the cell
highlight the characters (in the formula bar) that you want to give a special
format

and format|Cells
(or click the icons on the formatting toolbar)

Vlad wrote:

Using Excel 2000 - it is manually possible to create a cell, where the
first line of text is in italics and the remainder of the text in the
cell is normally formatted.

Can you part-format a cell using excel 2k?

If not can you achieve this on any other versions of excel.

TIA

Vlad


--

Dave Peterson