Can't change font property in Excel 2002

Giganews Newsgroups
Subject: Can't change font property in Excel 2002
Posted by:  Craig (rechj…@bigpond.com)
Date: Tue, 07 Oct 2003

I have been using the following code in a procedure that puts a red "X" in a
cell when you click on it. It works fine in Excel 97 / 2000 but not in Excel
2002 (Runtime error 1004: Unable to set Color property of font class). In
fact it won't change any properties of the font class.
Has there been a change in the newer version? All these properties still
appear as available.

********************************************************************

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

    Target.Value = "X"
          With Selection.Font
            .ColorIndex = 3
            .FontStyle = "regular"
        End With

Replies