+ Reply to Thread
Results 1 to 6 of 6

Adding/Deleting Shapes

Hybrid View

  1. #1
    Registered User
    Join Date
    05-27-2021
    Location
    US
    MS-Off Ver
    2016
    Posts
    3

    Re: Adding/Deleting Shapes

    Thanks again Greg! Your assumptions are correct -- vertical/angled for Closed/Open, and angled/horizontal for Open/Grounded. This scheme gets even more complicated when I pull in the interlocks with the HV side... not sure if this is the best software for the application, but without having a budget to develop anything else, I figured I'd give it a go. Though I'm sure you can guess by now that my expertise in VBa does not extend to this depth of operation!

    I'll attach another copy of the same sheet we've been discussing to show the overall layout including the HV system. The switches may be a bit difficult to see on the black lines, but there are essentially a 3-way on each side of each breaker in the ring bus, a 3-way from the ring bus to each feeder (3 transformers and 2 lines), and a 2-way high-speed ground switch just above those 3-ways to ground the high-side of the transformers or ends of line. That should make it about as clear as mud, but I think you'll get the picture :-)

    I'm for whatever works best, using the least amount of coding. So if one button transitioning through the 3 states Closed - Open - Grounded - Open - Closed works best, then let's try that avenue. If integrating permissive logic is easier into separate buttons, then let's try that. I truly have no preference either way without understanding what's involved to develop each.

    My wife and I just sold the farm, so to speak, so we're travelling nomads at the moment! We're originally from the South (SC to be exact) but have lived in Georgia and Southern California. We recently purchased an incredibly nice 5th wheel along with a new 1 ton truck to pull it with! So I'm a happy camper (pun intended) -- it's not as easy to keep the wife onboard with the notion, but she's being a really good sport so far (however, full disclosure: we've been hiding in the Caymans for work since 2 months after we got the rig LOL).

    My in-laws used to visit Ballymena quite regularly -- my father-in-law retired from Michelin. The photos from their trips along with all the ancestry research my wife's found of our lineages there makes me want to visit badly. Eventually, we'll get there -- maybe for a project! That would be fun, and I'd definitely reach out to have a pint (or 2) with you, if you're up for it.

    Thanks again for all your help! I've been wanting to learn more about this part of Excel for a while.

    Best Regards,

    Shannon
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA - Grouping Shapes & Deleting Them
    By CUCE in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 11-03-2020, 06:39 PM
  2. [SOLVED] Deleting shapes not working
    By peakoverload in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-15-2018, 01:09 PM
  3. [SOLVED] Shapes and Deleting Shapes
    By rob_h in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-24-2017, 10:07 AM
  4. Deleting Shapes
    By Dean81 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-25-2011, 01:25 PM
  5. Deleting Specific Shapes
    By FrankStallone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-15-2006, 01:43 AM
  6. [SOLVED] Deleting Shapes
    By aftamath in forum Excel General
    Replies: 5
    Last Post: 11-04-2005, 08:45 PM
  7. deleting all shapes and lines
    By thadpole in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2005, 06:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1