Organization Chart with VBA – Part 4

Worf

Well-known Member

Joined

Oct 30, 2011

Messages

4,252

• Aug 16, 2023

• #1

Worf submitted a new Excel article:

Organization Chart with VBA – Part 4 - This version offers a user interface for fine tuning

A request came up to accommodate wide boxes. Since it would be complicated to modify the core algorithm, I opted to prepare an interface where the user will be able to adjust the chart to their liking.

You will be presented with a basic chart without connectors; bring up the user form and arrange the boxes using the available options. When everything is ready, add the connectors.

Here is a more detailed description:

• Run the main routine to create the chart
• Run the user form...

Click to expand...

Read more about this Excel article...

 

U

Unterioncep

New Member

Joined

Nov 9, 2023

Messages

1

Office Version

1. 365

Platform

1. Windows

• Nov 9, 2023

• #2

This is some crazy development that you have done. Much thanks for your help, Wolf.
Sorry to bother you but I have one question. Do you think translating this into an ExcelScript would be feasible?

 

Worf

Well-known Member

Joined

Oct 30, 2011

Messages

4,252

• Nov 11, 2023

• #3

Hello

One of the VBA features I used was the ability to add Smart Art. Excel scripts do not seem to currently do it, so at this time it is not possible to translate.

 

I

iwannalearnmorestuff

New Member

Joined

Feb 12, 2024

Messages

2

Office Version

1. 365
2. 2016
3. 2013
4. 2011
5. 2010

Platform

1. Windows

• Feb 12, 2024

• #4

Is there a way to make this work for org-charts where you have entities that are "owned" by multiple entitites? I haven't seen it discussed anywhere (but can very well have missed something).

For example, if I want to make the org-chart in the submitted picture, the code seems to run into errors, presumably because of B1 being owned by multiple entities and E1 being owned by multiple entities.

I'm fairly new to all of this so I'm sorry if I missed including some important info.

 

Worf

Well-known Member

Joined

Oct 30, 2011

Messages

4,252

• Feb 17, 2024

• #5

Hi

I am currently busy with another project but in a few weeks, I plan to analyse this case.

 

I

iwannalearnmorestuff

New Member

Joined

Feb 12, 2024

Messages

2

Office Version

1. 365
2. 2016
3. 2013
4. 2011
5. 2010

Platform

1. Windows

• Feb 24, 2024

• #6

Awesome! I really love the work you've done so far, it's really cool what you've created