What is textrange2?

Question

Looking for support on finding text vba and ran into a lot of gobblygook about textrange2. What is it? How do you use it. What's it for, and so on. Examples?

John

Answer 1

You can place shapes such as rectangles, circles etc. on a worksheet. These shapes may contain a frame that contains text. In versions of Excel before Excel 2007, these were exposed to the programmer through the TextFrame and TextRange objects. In Office 2007, Microsoft introduced a new graphics engine with more capabilities; it is now possible to handle text in a shape almost as if it were text in a Word document. This is exposed to the programmer in the form of new objects that support the enhanced features: TextFrame2 and TextRange2. For reasons of compatibility, shapes also still have the older TextFrame and TextRange.

So you only need the TextRange2 object if you're working with shapes and if you want to make use of the new advanced text editing capabilities.

Answer 2

Where would I find more information on how to use that?

Thanks

John