I have about 50 shapes on my spreadsheet and about 10 are clickable, in that the shape changes its outline colour to black if selected. I am trying to write some code that will put the names of the selected shapes into a column on another worksheet. My problem is that my code counts the number of shapes that are selected and then returns shape names based on their index value not whether they were selected or not. Here is my code, please advise.
Please Login or Register to view this content.
Last edited by Leith Ross; 12-30-2015 at 06:52 PM. Reason: Added Code Tags
Hi kamazonka,
I Hope I understood your question correctly. I defined 'Selected Shapes' as shapes that are actually 'Currently Selected'.
See the attached file that includes the following code:
It is a best practice to declare all variables. If you misspell a variable in your code, VBA will silently assume it is a Variant variable and go on executing with no clue to you that you have a bug. Go to the VBA development window, click Tools, Options, and check "Require Variable Declaration." This will insert the following line at the top of all new modules:Please Login or Register to view this content.
This option requires all variables to be declared and will give a compiler error for undeclared variables.Please Login or Register to view this content.
I hope this helps.
Lewis
Thanks Lewis, this helps a lot.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks