Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-20-2022, 07:41 AM
BobbyS BobbyS is offline How to make a "modular" stencil Windows 11 How to make a "modular" stencil Office 2021
Novice
How to make a "modular" stencil
 
Join Date: Dec 2022
Location: Wisconsin
Posts: 5
BobbyS is on a distinguished road
Default How to make a "modular" stencil


So I have a cable stencil that will automatically add up to 10 wires if I right click and go to properties. This only adds wires on the left side of my stencil, but I would like them to also be added on the right side of the stencil.

Below is a picture and the shape file of the actual stencil. If you right click on the wires you can select properties at the top to add/delete/edit the wires.

If someone can point me in a direction for a video, or if you have the solution that would be great!

Thank you!

Last edited by BobbyS; 12-20-2022 at 08:05 AM. Reason: Attatchments
Reply With Quote
  #2  
Old 12-20-2022, 08:05 AM
BobbyS BobbyS is offline How to make a "modular" stencil Windows 11 How to make a "modular" stencil Office 2021
Novice
How to make a "modular" stencil
 
Join Date: Dec 2022
Location: Wisconsin
Posts: 5
BobbyS is on a distinguished road
Default Attachments for original post

Attachments that were supposed to be on the original post....
Attached Images
File Type: png Cable Stencil.png (36.4 KB, 7 views)
Attached Files
File Type: zip Cable Stencil.zip (15.3 KB, 1 views)
Reply With Quote
  #3  
Old 12-20-2022, 04:35 PM
Guessed's Avatar
Guessed Guessed is offline How to make a "modular" stencil Windows 10 How to make a "modular" stencil Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

That is a tricky little shape with lots of moving parts so it is hard to describe the various pieces that have to change.

I've amended it along the lines you asked for and added a couple of other settings so you can also vary the spacing and length of the lines.

If you want to study the changes I made:
Master shape - see ShapeSheet sections: Controls, User Defined, Shape Data
Child Shapes - see ShapeSheet sections: 1-D Endpoints, Geometry 1
Attached Files
File Type: zip Cable Stencil.zip (21.2 KB, 1 views)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 12-21-2022, 06:38 AM
BobbyS BobbyS is offline How to make a "modular" stencil Windows 11 How to make a "modular" stencil Office 2021
Novice
How to make a "modular" stencil
 
Join Date: Dec 2022
Location: Wisconsin
Posts: 5
BobbyS is on a distinguished road
Default Thank you!

Awesome, you're amazing. Thank you for the response it's very appreciated! I'll definitely look into the changes. I believe I was close to getting it, but I was missing a little detail somewhere.
Reply With Quote
  #5  
Old 12-21-2022, 12:06 PM
BobbyS BobbyS is offline How to make a "modular" stencil Windows 11 How to make a "modular" stencil Office 2021
Novice
How to make a "modular" stencil
 
Join Date: Dec 2022
Location: Wisconsin
Posts: 5
BobbyS is on a distinguished road
Default Wire-2 acting up

Again, thank you for the previously reply. After finally getting around to test the stencil out Wire-2 acts kind of funky. See attached picture. It is ONLY Wire-2. I can't figure out why the elbow part of it goes the opposite direction it should.

Also, if I wanted to add 2 more wire slots do I just create more rows in the shape sheet? I just can't seem to figure out where the drawing of the wire is done in the shape sheet.

Thanks for any help
Attached Images
File Type: png Wire-2.png (25.0 KB, 6 views)
Reply With Quote
  #6  
Old 12-21-2022, 03:34 PM
Guessed's Avatar
Guessed Guessed is offline How to make a "modular" stencil Windows 10 How to make a "modular" stencil Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You need to understand that your 'shape' is actually a nest of shapes. The parent shape contains a bunch of children shapes. Each shape has its own shapesheet and formulas can point up to the parent shapesheet fields or any of the child shapesheet fields.

The reason you can't find the wires on the shapesheet is that the geometry of each wire is on each of the child shapesheets. To edit a child shapesheet, you need to click once on the parent shape (you will see the main shape handles show it is selected), THEN click on the wire (you should see the selection handles change to the line ONLY and the title in the Shape Data window changes to the Wire). NOW right click on that wire and choose to view the ShapeSheet.

In the screenshot, you can see that in this case we are looking at the shapesheet for Wire2 and that the parent shape is called Sheet.1 so the formula that points at the position of Wire2's second geometry position is using the width of the line and 10% of the size in the parent shape's Scratch.B1 cell. To move that point to the right (instead of the left), change the minus to a plus
=Width - 0.1*Sheet.1!Scratch.B1
should be
=Width + 0.1*Sheet.1!Scratch.B1
Attached Images
File Type: jpg 2022-12-22_9-25-30.jpg (125.2 KB, 5 views)
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #7  
Old 12-22-2022, 06:30 AM
BobbyS BobbyS is offline How to make a "modular" stencil Windows 11 How to make a "modular" stencil Office 2021
Novice
How to make a "modular" stencil
 
Join Date: Dec 2022
Location: Wisconsin
Posts: 5
BobbyS is on a distinguished road
Default

Awesome, that makes a lot more sense, thank you!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003: VBA "Function" causes "#VALUE!" errors after running "insert/delete row" custom macro Matt C Excel Programming 2 01-08-2022 06:03 AM
Make "automatic" dimensions show all the time not just when editing macleodal Visio 1 11-27-2018 08:48 PM
How can I make VBA to "crop to fit" all pictures to picture placeholders across all slides at once? jamesupshaw PowerPoint 3 04-28-2017 09:35 AM
How to make a "modular" stencil Mailing: how to make the "page number" in Word is the same as "row number" in excel w Jamal NUMAN Word 1 09-03-2011 11:37 AM
How to make a "modular" stencil How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:42 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft