Microsoft KB Archive/113599

= Can't Format Control Text in Objects Such As EditBox and Range =

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.