Microsoft KB Archive/931381

From BetaArchive Wiki
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Knowledge Base


Visual Basic for Applications returns an unexpected value when you use Visual Basic for Applications in Excel 2007 to obtain the value of a Border.LineStyle property

Article ID: 931381

Article Last Modified on 10/15/2007



APPLIES TO

  • Microsoft Office Excel 2007



SYMPTOMS

When you use Microsoft Visual Basic for Applications (VBA) in Microsoft Office Excel 2007 to obtain the value of a Border.LineStyle property, VBA returns an unexpected value. This issue occurs if the following conditions are true:

  • You try to obtain the value of a Border.LineStyle property from a chart object or from a shape object.
  • The chart object or shape object was created in an earlier version of Excel.


STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.


Additional query words: xl2007

Keywords: kbtshoot kbchart kbprb KB931381