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

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: 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: 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.