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           : WINDOWS:5.0,7.0; MACINTOSH:5.0
Platform          : MACINTOSH WINDOWS

Last Reviewed: February 4, 1998