ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Highlight / "Selection" of AutoShape Text (Like SelStart for TextBoxes) (https://www.excelbanter.com/excel-programming/329659-highlight-selection-autoshape-text-like-selstart-textboxes.html)

James Cox[_2_]

Highlight / "Selection" of AutoShape Text (Like SelStart for TextBoxes)
 
Anyone know how to duplicate the visual effects of SelStart and SelLength
(which are properties only of TextBoxes and ComboBoxes) on the text in an
AutoShape?

I'm not having much luck in figuring out how to do that. I can use the

.Characters(Start:=j, Length:=k)

syntax to get the right characters (after a Find operation) but can't figure
out a non-permanent way to visually mark the found text (changes made with
the .Font object appear to be pretty permanent).

Any help would be most appreciated!

James Cox




All times are GMT +1. The time now is 04:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com