Maciej
12-13-2014, 04:49 AM
Dear All,
I would like to kindly ask you for support.
I have checked almost whole internet :banghead: and I don't now, how to solve my problem.
I would like to create a macro, which will create a block diagram.
Let me explain based on on the example of the organizational structure, because it will be the first sample, where I will use this solution
Is it possible to do it in excel, a VDA/ macro, that when you press a button to create a diagram, it will create a scheme knowing:
- How many levels are vertically - Column A
- How many in each level is the level horizontally - Column C
- Enter a name to each block - Columns D-H
I thought about inserting scheme with SmartArt (file - Proposal 2), but he has some limit to the number of levels. So is it possible to do it by inserting into the cells and then simply reformatting them, add border, add something like the arrow (in file - Proposal 1)?
The assumption is that when it will be use it will have different amounts of levels and blocks at each level.
Thank you in advance for your help, because now I'm fighting with his for a long time and I am blocked, For 100% I will not do it by myself : pray2:
When an my post replies, please take into account that the I am not a "master" of VBA, so it will be possible, that I will not understand some VDA words and language :*)
Regards and once again thank you in advance
I would like to kindly ask you for support.
I have checked almost whole internet :banghead: and I don't now, how to solve my problem.
I would like to create a macro, which will create a block diagram.
Let me explain based on on the example of the organizational structure, because it will be the first sample, where I will use this solution
Is it possible to do it in excel, a VDA/ macro, that when you press a button to create a diagram, it will create a scheme knowing:
- How many levels are vertically - Column A
- How many in each level is the level horizontally - Column C
- Enter a name to each block - Columns D-H
I thought about inserting scheme with SmartArt (file - Proposal 2), but he has some limit to the number of levels. So is it possible to do it by inserting into the cells and then simply reformatting them, add border, add something like the arrow (in file - Proposal 1)?
The assumption is that when it will be use it will have different amounts of levels and blocks at each level.
Thank you in advance for your help, because now I'm fighting with his for a long time and I am blocked, For 100% I will not do it by myself : pray2:
When an my post replies, please take into account that the I am not a "master" of VBA, so it will be possible, that I will not understand some VDA words and language :*)
Regards and once again thank you in advance