Finding itallics (1 Viewer)

gpurger

Registered User.
Local time
Today, 01:36
Joined
Apr 21, 2004
Messages
66
Hi,
is there a way in excel 2000 to find if part of the information in a cell is in itallics or not.

Cheers

G
 

shades

Registered User.
Local time
Today, 03:36
Joined
Mar 25, 2002
Messages
516
Howdy. This is a function in VBA, that you can access as any other function in Excel.

Code:
Function ISITALIC(cell) As Boolean
   'Returns TRUE if cell is italic
   'Returns error if the cell is mixed
   ISITALIC = cell.Range("A1").Font.Italic
End Function

The following will return TRUE if all characters are italic.

Code:
Function ALLITALIC(cell) As Boolean
   'Returns TRUE if all characters in cell are italic
   If IsNull(Cell.Font.Italic) Then ALLITALIC = False
   Else
      ALLITALIC = cell.Font.Italic
   End If
End Function
________
ARIZONA MARIJUANA DISPENSARIES
 
Last edited:

Users who are viewing this thread

Top Bottom