+ Reply to Thread
Results 1 to 4 of 4

HELP: How to implement Nested/Hierarchy Checklist?

  1. #1
    Registered User
    Join Date
    12-26-2016
    Location
    SA, KSA
    MS-Off Ver
    2010, 2013, 2016, 2019
    Posts
    44

    Post HELP: How to implement Nested/Hierarchy Checklist?

    Dear Experts,

    I was looking for interactive checklist and found very good example at this link.

    I have attached one of the example file taken from there.
    checklist.PNG

    I was wondering if it's possible to create a nested list/hierarchy based on this attached example i.e. Topic.Subtopic.subsubtopic.item, ( list goes up to five levels deep e.g. 2.1.5.3.1 ) ? In the attached example when user clicks on Topic the items related to this topic Collapse/hide.

    The author commented to one of the user there as
    The current implementation simply differentiates between topics and items using two Boolean functions (IsItem and IsTopic). The functions check whether there is a separator (a period) in the first column of the list and if there is one, it is an item, otherwise it is a topic.
    not only check if there is a separator, but rather count the separators to decide which level has been checked.
    someone please help me !!!!, I have no VBA experience, unfortunately.
    Attached Files Attached Files
    Last edited by qadeerume; 07-28-2020 at 10:25 PM. Reason: added screenshot and some wordings changed in title and msg.

  2. #2
    Registered User
    Join Date
    12-26-2016
    Location
    SA, KSA
    MS-Off Ver
    2010, 2013, 2016, 2019
    Posts
    44

    Re: HELP: How to implement Nested/Hierarchy Checklist?

    anyone please???

  3. #3
    Registered User
    Join Date
    12-26-2016
    Location
    SA, KSA
    MS-Off Ver
    2010, 2013, 2016, 2019
    Posts
    44

    Re: HELP: How to implement Nested/Hierarchy Checklist?

    no one !!! ??

  4. #4
    Registered User
    Join Date
    12-26-2016
    Location
    SA, KSA
    MS-Off Ver
    2010, 2013, 2016, 2019
    Posts
    44

    Re: HELP: How to implement Nested/Hierarchy Checklist?

    any VBA Expert, please help me out !

+ 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. Using Excel to create a hierarchy SMart Art
    By L.forster in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-26-2019, 02:47 AM
  2. Create hierarchy using VBA objects
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-11-2018, 12:59 AM
  3. How do I convert column hierarchy to flat file hierarchy
    By tbucki1 in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 09-21-2016, 09:33 PM
  4. how to create (and use) an hierarchy
    By apolloni in forum Excel General
    Replies: 8
    Last Post: 04-09-2015, 07:56 AM
  5. Hierarchy Indented List, Table, Column and Value - need to create uniqueid column
    By mcolli01 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-06-2012, 01:09 PM
  6. How to create selction in an Hierarchy?
    By dreams in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-11-2009, 06:46 PM
  7. Create Hierarchy in Excel
    By rajeshkamath27 in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-19-2008, 11:44 AM

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