+ Reply to Thread
Results 1 to 4 of 4

Selected shape index number

  1. #1
    Registered User
    Join Date
    02-04-2012
    Location
    UK
    MS-Off Ver
    Excel 07
    Posts
    12

    Selected shape index number

    Hi all,

    I'm after a way to determine a selected shapes' index number.

    Thanks
    Last edited by Weston33; 02-14-2012 at 03:09 AM.

  2. #2
    Registered User
    Join Date
    12-18-2011
    Location
    Back in Warwickshire
    MS-Off Ver
    365
    Posts
    59

    Re: Selected shape index number

    Could you expllain a bit more

  3. #3
    Registered User
    Join Date
    02-04-2012
    Location
    UK
    MS-Off Ver
    Excel 07
    Posts
    12

    Re: Selected shape index number

    I would like to find the index number of a shape in a worksheet. I can get the name by using the index number i.e.
    Please Login or Register  to view this content.
    But how do I determine the '1' in the first place?

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Selected shape index number

    That is the index position in the collection which can change when the zorder of shapes is changed.
    What exactly are you trying to do?

    if you add three shapes to a sheet and give each shape some unique text to help identify it.
    Now run this code and see the order and index change.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1