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

ID: Q113599

The information in this article applies to:

Microsoft Excel for Windows, version 5.0
Microsoft Excel for the Macintosh, version 5.0
Microsoft Excel for Windows 95, version 7.0

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.

Additional query words:

Keywords : kbprg
Version : MACINTOSH:5.0; WINDOWS:5.0,7.0
Platform : MACINTOSH WINDOWS
Issue type :