Article ID: 113599
Article Last Modified on 8/15/2005
APPLIES TO
- Microsoft Excel 95 Standard Edition
- Microsoft Excel 5.0 Standard Edition
- Microsoft Excel 5.0 for Macintosh
This article was previously published under Q113599
SUMMARY
In Microsoft Excel, you can use the Characters method with some objects to return a range of characters in the object text. This procedure allows you to format characters in a text string.
Both the Object Browser and Visual Basic Help indicate that the Characters method applies to the following objects:
AxisTitle
Button
Buttons
ChartTitle
CheckBox
CheckBoxes
DataLabel
DialogFrame
DrawingObjects
DropDown
DropDowns
EditBox
EditBoxes
GroupBox
GroupBoxes
Label
Labels
OptionButton
OptionButtons
Range
TextBox
TextBoxes
The text for controls such as edit boxes and check boxes cannot be formatted; therefore, the Characters method cannot be applied to the objects for these controls.
The Characters method may be applied only to the following objects:
AxisTitle
Button
Buttons
ChartTitle
DataLabel
DropDowns
Range
TextBox
TextBoxes
NOTE: You cannot use the Characters method to change character formatting for a DropDown object; however, you can use the Characters method to set or return characters for the text in a combination drop-down edit box.
Keywords: kbprogramming KB113599
