Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts

    Working with Shape names

    Trying to make my code tidier and more understandable, I've started to name the various shapes on my Excel Worksheets.

    With range names I can look up a name and see which location it refers to.

    Is there an equivalent method of looking up shape names, or do I have to rely on giving them such obvious names that I can work it out ? At the moment I am prefixing each name with its Worksheet name, followed by a brief description.

    Thanks
    Last edited by MartinM; 2016-01-09 at 10:20.

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    9,433
    Thanks
    371
    Thanked 1,456 Times in 1,325 Posts
    Martin,

    Here's some code that will do that and a bit more. You can adapt to meet your needs.

    HTH
    May the Forces of good computing be with you!

    RG

    PowerShell & VBA Rule!

    My Systems: Desktop Specs
    Laptop Specs

  3. The Following User Says Thank You to RetiredGeek For This Useful Post:

    MartinM (2016-01-09)

  4. #3
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Lovely thanks RG - I'm busy adapting, and it's going well

  5. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,631
    Thanks
    115
    Thanked 645 Times in 589 Posts
    Martin,

    Why not just open and dock the selection pane for as long as you need it? Each shape is clearly identified by its name. You can temporarily hide which ever shapes you want while working on other shapes or just the worksheet. It also provides an easy way to change the shape's name as well as multi selecting them as a group.

    Home Tab > Find and Select > Selection Pane...

    Make sure you naming convention provides a way to loop through them in code if/when needed.

    HTH,
    Maud

  6. #5
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    Ah - one of the few penalties of using Excel 2003 !

    However my naming scheme is as logical as you could wish.

Posting Permissions

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