• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 441
  • Last Modified:

How do I determine selected text in the title of a PowerPoint chart using VBA 2010?

Hello all.

Does anyone know how to extract the selected text (if any) in the title of a chart in PowerPoint 2010 using VBA?

"...Selection.TextRange" and "...Selection.TextRange2" don't work (I get a "... value out of range" error). Also, "...Selection.HasChildShapeRange" returns false.

I know about "...Selection.ShapeRange(1).Chart.ChartTitle.Caption", but that returns the whole title, not the text selected within it...

I'm stumped!

Thanks in advance for any help...
0
RIBBIT_Productions
Asked:
RIBBIT_Productions
  • 2
  • 2
1 Solution
 
JSRWilsonCommented:
There's no way to do this (and it's a major oversight in my view). As you suggest you can get the whole title but not the selection.  You can get it in Excel but not in Powerpoint.

Any reference to Selection will return the chart. The only way I can think of is to call copy using CommandBars.ExecuteMso("Copy") and then paste the text somewhere to read it. My experience is this is unreliable but might be worth playing.
0
 
RIBBIT_ProductionsAuthor Commented:
Thanks, JSRWilson. I ended up using "...selection.copy" which I think is more reliable than the ExecuteMso command - correct me if I'm wrong...

Whatever the method though, copying the selection changes the content of the clipboard, which I don't like, but after researching some more I can't find a better solution so it will have to be it.

Happy new year everyone!
0
 
RIBBIT_ProductionsAuthor Commented:
I've requested that this question be closed as follows:

Accepted answer: 0 points for RIBBIT_Productions's comment #a39746618

for the following reason:

Found better solution.
0
 
JSRWilsonCommented:
Actually it is exactly the same!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now