Previous in Forum: Add Connector Between Two Shapes/Group Of Shape   Next in Forum: Help Me to Get Rid of the Ask Search Toolbar
Close

Comments Format:






Change Mode
Close

Subscribe to Discussion:

CR4 allows you to "subscribe" to a discussion
so that you can be notified of new comments to
the discussion via email.

Close

Rating Vote:







Add Vote
4 comments
Rate Comments: Nested
amitabha0107
Power-User

Join Date: Feb 2011
Location: Shimurali, Westbengal,India
Posts: 119

VBA Excel 2007 Code for Connected Shape Handling

09/13/2013 1:01 AM

This is regarding shape handling in excel 2007.

In my work sheet I place a lot of Autoshapes of different names as per program. Few of the shapes are interconnected by elb-oconnector. Also, each shape has a specific value as it is created and the value is stored in a cell of another sheet of the workbook.

Now, on the shapes few shapes name start with G1,G2,G3...and few T1,T2,T3...,few B1..In these shape few switches are places, named as S1,S2..

I want to check

1. G1/G2/G3.. is connected to B1/B2/B3 any way i.e. through G1/G2/G3.. and S1/S2.

2. If G1 (say) connected to B1 (say) then sum the values for G1 and T1 (if any in between G1 and B1).

Please help me.
Register to Reply
Interested in this topic? By joining CR4 you can "subscribe" to
this discussion and receive notification when new comments are added.
SolarEagle
Guru

Join Date: Mar 2007
Location: by the beach in Florida
Posts: 33392
Good Answers: 1817
#1

Re: VBA excel 2007 code for Connected shape handling

09/13/2013 1:12 AM

This might help....

http://peltiertech.com/WordPress/programming-excel-2007-2010-autoshapes-with-vba/

__________________
 All living things seek to control their own destiny....this is the purpose of life
Register to Reply
amitabha0107
Power-User

Join Date: Feb 2011
Location: Shimurali, Westbengal,India
Posts: 119
#2
In reply to #1

Re: VBA excel 2007 code for Connected shape handling

09/13/2013 3:36 AM

This is not in line with my requirement.
Register to Reply
PWSlack
Guru
United Kingdom - Member - Indeterminate Engineering Fields - Control Engineering - New Member

Join Date: Jan 2007
Location: In the bothy, 7 chains down the line from Dodman's Lane level crossing, in the nation formerly known as Great Britain. Kettle's on.
Posts: 32175
Good Answers: 839
#3
In reply to #2

Re: VBA excel 2007 code for Connected shape handling

09/13/2013 3:46 AM

Excel is great for doing calculations. For drawing, try Visio instead.

__________________
 "Did you get my e-mail?" - "The biggest problem in communication is the illusion that it has taken place" - George Bernard Shaw, 1856
Register to Reply
ci139
Guru

Join Date: Feb 2012
Posts: 595
#4
In reply to #2

Re: VBA excel 2007 code for Connected shape handling

09/15/2013 5:24 AM

i think the link above is of a great help for parameter names reference
-- anyway if you do a procedural guides like this
and try to simplify your work -- the question is
1) (this is a programmers job) - where's yours
2) isn't there a speciffic application for such (in excel you can do a lot of damage by unintended formatting -- which you have to stay aware of -- e.g. -- handle exceptions programmatically (to be able you have to know all such = enormous time for testing))
3) if you try to economize (do all 1) & 2) ) where is the complte problem description (such as what exactly you want to sum e.c. e.c.)

__________________
 ci139
Register to Reply
Register to Reply
Have a Different Question?
4 comments
Copy to Clipboard

Users who posted comments:

amitabha0107 (1); ci139 (1); PWSlack (1); SolarEagle (1)

Previous in Forum: Add Connector Between Two Shapes/Group Of Shape   Next in Forum: Help Me to Get Rid of the Ask Search Toolbar

Advertisement

Got Something to Say?
Ask a Question
Start a Discussion

Search this Forum
Software & Programming:
Go

CR4 Sections
Aerospace
BioMech & BioMed
Chemical & Material Science
Civil Engineering
Communications & Electronics
Education and Engineering Careers
Electrical Engineering
General Discussion
Instrumentation
Manufacturing
Mechanical Engineering
New Technologies & Research
Software & Programming
Sustainable Engineering
Transportation

Site Directories
Forum Directory
Blog Directory
User Group Directory
RSS Feeds

CR4 Rules of Conduct
CR4 FAQ
Site Glossary

Who's Online (89 right now)
Show Members
Advertisement