Thread: Get the TEXT of Clicked Shape
View Single Post
 
Old 07-03-2014, 02:39 AM
exceere exceere is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Jun 2014
Posts: 7
exceere is on a distinguished road
Default Get the TEXT of Clicked Shape
Hi, i need a help

I have Three Shapes their texts are A, B, and C

These shapes all have the same name (UF_SinlgeList)

i use the following code to get the text of clicked shape

Code:
     ActiveSheet.Shapes(Application.Caller).Select
     
     MsgBox (Selection.Text)
when i click shape A the returned text is B, why???

(in my case i need the three shapes to have the same names)

Thanks for help
Reply With Quote