+ Reply to Thread
Results 1 to 2 of 2

Excel VBA Data entry with parent-child (treestructure)

  1. #1
    Registered User
    Join Date
    04-24-2023
    Location
    Suomi
    MS-Off Ver
    2016
    Posts
    1

    Excel VBA Data entry with parent-child (treestructure)

    Hi,

    I should create userform where I would be able to entry data in to table as groups with subdata,

    Group1 (parent)
    -item1(child)
    -item2(child)

    Group2(parent
    -item1(child)
    -item2(child


    etc.
    In the userform, there should be entrybox for group name and item names, after typing the names, the groups should be save into table.
    The data should be visible in the listbox and should be manageable via the userform (delete groups, update groups)

    Could you help me?

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,587

    Re: Excel VBA Data entry with parent-child (treestructure)

    Pl read yellow banner above.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

+ 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. Extracting data to create a Parent-Child Hierarchy
    By arpitprakash in forum Excel General
    Replies: 10
    Last Post: 03-17-2022, 12:11 AM
  2. Juxtaposing successive levels from parent-child relational data
    By Marbleking in forum Excel Formulas & Functions
    Replies: 22
    Last Post: 07-08-2020, 11:41 PM
  3. Replies: 26
    Last Post: 12-30-2018, 04:25 PM
  4. [SOLVED] Parent Child relationship issue: Get parent ID for child
    By masterl1983 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 08-28-2018, 07:35 AM
  5. Adding parent row data to child row
    By firepitz in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-16-2017, 02:19 PM
  6. Copy data fom parent file to child files with different layouts
    By Marloes in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-14-2014, 05:12 AM
  7. Replies: 3
    Last Post: 07-09-2010, 02:54 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