Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #7  
Old 07-08-2014, 09:13 PM
excelledsoftware excelledsoftware is offline Get the TEXT of Clicked Shape Windows 7 64bit Get the TEXT of Clicked Shape Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

Hi Bob, I thought the same thing but the only thing I can get the shaperange to return is the count. Even when I declare a variant anything like shpName = activesheet.selection.shaperange.name or shpName = activesheet.selection.shaperange just returns an empty variable. The other issue is that when a shape is programmed to a macro and then ran the shape does not get selected. At least from what I can tell. If someone can figure out what we can return with shaperange we might be able to do it the other way but I don't think it's possible with all the shapes having the same name. Though I could be wrong.
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copied shape/text box pastes as an image in Word spectator Word 0 06-04-2014 08:45 AM
Get the TEXT of Clicked Shape how to paste text as shape bsapaka Excel 1 05-01-2014 06:53 AM
Shape+text issue when saving to PDF HMS Word 1 07-12-2013 04:43 PM
Get the TEXT of Clicked Shape autofit text to shape (msoShapeRectangle) viuf PowerPoint 2 02-20-2012 02:11 PM
Get the TEXT of Clicked Shape Adding text to auto shape and rotating Hot Mumma Word 1 06-14-2011 05:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:45 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft