Hi All,
I have a requirement to create a flow chart (with just rectangle boxes and one sided arrows). e.g.
Job A triggers Job B
Job B triggers Job C and Job D
Job C triggers Job E
I want to put this in a flow chart/org chart sort of thing. I am able to create one where a job is triggering only one job. Not very sure how branching can be done in VBA. Any help/pointers will be appreciated. Thanks in advance
My suggestion would be this isn't really something I'd try to do in Excel. More a job for Visio.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
Perhaps you could avoid using VBA and just make a regular chart using the draw functions in Excel. You can also use PowerPoint for this, which you are more likely to have already if you are using Excel.
Will Orgcharts in VBA be of any help here and then probably use nodes?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks