Read what's in the shape

[Killersanta]

What I basically want is a line of code that can read what's in a shape. So if I click on a shape with a macro assigned to it, that macro reads which text is in the shape so it can look for it in a list and get the other information. So what I need is some code (as short as possible) that reads what's currently in the shape button on which I clicked.

 

[JLeno]

In the Immediate Window in the Visual basic editor (press Ctrl + G if you don't see an immediate window), insert

?selection.text

and press enter.

Make sure the shape is selected.

Cheers!

 

[Killersanta]

But isn't there a way for the macro to select the shape on which I clicked and then reads what's in it? Because I have a lot of shapes that are auto generated and all have the same macro. I basically need to make a system for a diner to take orders and such for school but if you have to select something first it's not really user friendly or professional because when you select a shape you see options to turn it, or make it bigger etc.

 

[JLeno]

If the shape is selected you can use "Selection.Text". Depending on what you want you get

MsgBox Selection.Text, or
Debug.Print Selection.Text

or something else.

Good luck!