Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-08-2022, 03:18 AM
benjamin213 benjamin213 is offline Count shape in a mock-up in MS Visio Windows 10 Count shape in a mock-up in MS Visio Office 2019
Novice
Count shape in a mock-up in MS Visio
 
Join Date: Jun 2022
Posts: 2
benjamin213 is on a distinguished road
Smile Count shape in a mock-up in MS Visio

Hello everyone,
I am totally new with MS Visio, and I'm lost.
I need to count each item in a bay.


I don't have a lot of information except position of each items, and a label for each items that say how much an item take place in a bay ( 1 U or 2 U or 3 U ...)
How can i proceed ?
Attached Images
File Type: jpg png.jpg (207.3 KB, 14 views)
Reply With Quote
  #2  
Old 06-08-2022, 04:24 PM
Guessed's Avatar
Guessed Guessed is offline Count shape in a mock-up in MS Visio Windows 10 Count shape in a mock-up in MS Visio 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

Since you haven't posted a sample file we can only guess at how your racks are structured. You can use a macro to count the shapes and subshapes on each page. This code below returns the output to the immediate window. You could modify it to process all pages or just the selected shapes depending on what you actually need it to do.
Code:
Sub CountEmUp()
  Dim aShp As Shape, aSubShape As Shape
  For Each aShp In ActivePage.Shapes
    Debug.Print aShp.Text, aShp.Master, aShp.Shapes.Count
    If aShp.Shapes.Count > 0 Then
      For Each aSubShape In aShp.Shapes
        Debug.Print "", aSubShape.Text, aSubShape.Master, aSubShape.Shapes.Count
      Next aSubShape
    End If
  Next aShp
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #3  
Old 06-09-2022, 04:47 AM
benjamin213 benjamin213 is offline Count shape in a mock-up in MS Visio Windows 10 Count shape in a mock-up in MS Visio Office 2019
Novice
Count shape in a mock-up in MS Visio
 
Join Date: Jun 2022
Posts: 2
benjamin213 is on a distinguished road
Default

Yes sorry I'll explain with more details.
i need to count each items in one bay and detect also how many slots its used. for example in this picture the last item use 12 slots.
I can't upload my file so i give you a wetransfer : WeTransfer - Send Large Files & Share Photos Online - Up to 2GB Free
it is not my file and i am a beginner with MS Visio so i don't understand a lot,
what are the scripts for, in vba.
Thank you by advance.
Attached Images
File Type: png png2.PNG (80.1 KB, 9 views)
Reply With Quote
Reply

Tags
visio 2010 standard

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Visio 2019 standard: How to import a custom shape EveA Visio 1 01-24-2022 12:36 AM
Visio 2016 New homemade Shape Data export with Network Shape Data Karlderxte Visio 1 08-17-2021 04:04 PM
Add fields to shape in the desktop after using the visio excel add inn rosscortb Visio 1 08-16-2021 03:42 PM
Count shape in a mock-up in MS Visio How do I lock shape positions in Visio 2010 redwards60 Visio 1 08-11-2015 05:41 AM
VISIO - Formatting Shape Data Details TABLE Lora Visio 0 07-19-2010 12:15 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 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