Excel VBA Tree Control Facet Chooser


Excel VBA Tree Control Facet Chooser

1. After selecting a cell, a user clicks a button on the sheetwhich launches a popup form.

2. The form displays an expandable tree control containing nested checkboxes, populated from our hierarchical attributes tree (see attached). The list of attributes as well as the Attribute IDs are stored in columns in a lookup sheet.

3. The user selects one or more facet members by clicking on one or MORE checkboxes in the popup tree.

4. The user clicks an "Insert Attributes" button located on the popup box.

5. The cell is populated with a list of Attribute ID Numbers in a comma separated list (I.E. "1024, 1655, 1759, 2044").

6. A validation rule will disallow parent-child, parent-grandparent, etc. from being tagged and submitted simultaneously. E.G. Users cannot select both Blues AND Blues Folk for a single track row.

7. Separate from requirement 6 above, users CAN select multiple siblings and assign those facet members to a single track row.

8. If a cell already contains data, when a user clicks the popup button, the app will scan the cell for existing data. If it already contains comma separated category #s, the tree will be pre-populated with that existing data.

9. User export to a format optimized to meet the APM requirements for ingestion into Music Source.

Skills: Excel, Software Architecture, Visual Basic, Visual Basic for Apps

See more: excel vba tree, excel tree, vba tree control, tree control vba excel, tree to box, tree insert, expandable list, app vba, apm music, excel vba with, excel vba or, excel vba and, excel 2013 vba, vba e, the tree, excel/vba, apm, control attribute, excel contains, tree control columns, app basic excel, excel vba row source, sheet excel visual basic, 2013 excel visual basic, excel format cell

About the Employer:
( 160 reviews ) Cairo, Egypt

Project ID: #4381726

12 freelancers are bidding on average $126 for this job


Excel VBA expert with great experience here....Lets discuss in detail.Also send me attachment you stated in descriptions.

$147 USD in 3 days
(75 Reviews)

Hello DandDSolutions, your need is pretty simple. Looking foreward. Pierre

$154 USD in 3 days
(25 Reviews)

More than 15 years of programming experience. Professional VBA solutions and webscraping, data mining and automated bots. Please check the SOLUTION in PM. Best regards Filipe Francisco , VB Expert ===================== More

$154 USD in 3 days
(11 Reviews)

Dear Sir, This seems to be an easy job for me. Please send the file to start.

$145 USD in 3 days
(9 Reviews)

Hi, your excel vba expert here. I believe you prefer to work with a top freelancer as you are. regards,

$140 USD in 5 days
(14 Reviews)

Hi,We are VB/VBA Expert can bring almost VB in Excel Macro,Please see our Past & Present Works

$200 USD in 8 days
(8 Reviews)


$55 USD in 2 days
(9 Reviews)

Ready to initiate the project and willing to deliver the perfect output you desire. Details on PM

$130 USD in 3 days
(1 Review)

I am new to Free Lancing, but not to VBA. You can expect the best solutions for your requirements.

$77 USD in 2 days
(0 Reviews)

Hi, I am interested in your project. You can count on me for fast and 100% quality job done. Thanks, Andras

$154 USD in 3 days
(0 Reviews)

I'm working as a software engineer in Japan company. And I used to worked on VBA project for many times. Are you missing an attachment file? Low price but high quality !!!

$110 USD in 7 days
(0 Reviews)

We have big experience in software development. We can make this project at high level. We want to know more details about this project.

$50 USD in 3 days
(0 Reviews)

I am seriously interested in your project

$100 USD in 3 days
(0 Reviews)