Results 1 to 2 of 2

Help with Hierarchical Structure in Excel

Threaded View

  1. #1
    Registered User
    Join Date
    01-12-2015
    Location
    Colorado
    MS-Off Ver
    2010
    Posts
    2

    Question Help with Hierarchical Structure in Excel

    Hey guys, I have been working on a project in Excel for weeks with no luck.

    What I am trying to make is an interactive BoM (bill of materials) setup almost like a Family Tree with buttons to add new child items. I've been working on coding this for weeks with no luck. Here is a link to my youtube video that visually explains exactly what I am looking for.

    I guess the main question is, what is the best way through VB to set up a hierarchical structure like that in the video?

    Requirements are:
    - Staying away from SmartArt
    - Need buttons to add items and child items
    - Must be able to add a new child anywhere without messing up the alignment of other rows
    - All items must be separated by 1 space.
    - Parent items must always re-size to contain all its child items, with a step of 1 cell for both top and bottom
    - New Items are always 5 cells long

    Problems I have had with my VB

    - Because my buttons have macros referencing specific ranges of cells telling where to place the next child item, they get misaligned whenever item boxes are resized and added.

    I think this will turn into a useful BoM tool for anyone to use, so the more people to help with this the better!

    Thanks again!
    Last edited by JKtoC; 01-16-2015 at 03:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a Pyramid Hierarchy structure from a flat structure
    By thegamerulez in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-16-2014, 01:28 AM
  2. How do I group rows hierarchical (1, 1.1, 1.1.2 ...)
    By jugeh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-09-2013, 05:19 PM
  3. "convert" data with logfile structure to spreadsheet structure
    By boarders paradise in forum Excel General
    Replies: 7
    Last Post: 01-10-2011, 02:06 AM
  4. Hierarchical List
    By Paul in forum Excel General
    Replies: 1
    Last Post: 08-02-2006, 09:05 AM
  5. Hierarchical Worksheet Tabs??? New Excel feature?
    By JMcC in forum Excel General
    Replies: 1
    Last Post: 10-11-2005, 12:05 PM

Tags for this Thread

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