+ Reply to Thread
Results 1 to 3 of 3

Issue on filling grouped shapes

  1. #1
    Registered User
    Join Date
    01-24-2020
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    95

    Issue on filling grouped shapes

    Dear gurus,

    I've racked my brain for this seemingly easy issue without solution; so, I turn to you for help!

    I've got a bunch of groups shapes (maps of some European states). Some countries consist of incontiguous territories, like France, Italy etc. I failed to apply such method to them while succeding in some other single shapes!
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    What's really weird is that a macro snippet is recorded on changing the "visible" attribute via Selection panel.

    Pls refer to the attachment for details. Your help is much appreciated! Have a nice weekend!
    Attached Files Attached Files

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

    Re: Issue on filling grouped shapes

    The groupitems collection only works for a single depth.

    So the shapes Spain, Ireland etc work and can be, via code, identified as being grouped in "Group 44"
    The shapes group in Italy are also considered part of Group 44, rather than group Italy grouped within Group 44.

    If you list the groupitems of Group 44, you get

    Spain
    Portugal
    Ireland
    FR2
    FR1
    North Ireland
    England
    Wales
    Scotland
    It3
    It2
    It1
    Switzerland
    Austria
    Germany
    Belgium
    Luxembourg
    Netherlands

    Notice the missing inner groups.
    You would have to either ungroup so you have countrys and country groups.
    Or change the names of the grouped countrys such that you can loop through all the grouped items and identify parent, e.g.

    ITALY_IT1
    ITALY_IT2
    ITALY_IT3
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-24-2020
    Location
    Belgium
    MS-Off Ver
    2013
    Posts
    95

    Re: Issue on filling grouped shapes

    Thx a lot, Andy! I'll try to change the hierarchy of the shapes' group then.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 01-03-2019, 09:12 AM
  2. Replies: 3
    Last Post: 04-18-2017, 03:48 AM
  3. [SOLVED] Filling colors in random shapes
    By freeofcost in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-21-2014, 06:01 AM
  4. Grouped Shapes
    By treva31 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2010, 04:46 AM
  5. Delete grouped shapes?
    By Dr.Ile in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-30-2006, 06:00 AM
  6. [SOLVED] Assigning Macros to Grouped Shapes
    By Spinner in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-30-2005, 11:45 AM
  7. [SOLVED] Names of Grouped Shapes
    By Mogwai in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-07-2005, 03:05 PM

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