• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

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