AnsweredAssumed Answered

macro to read balloon content in Drawing and change the note

Question asked by Peter Pankras on Oct 16, 2018
Latest reply on Oct 17, 2018 by Peter Pankras

Hi,

 

I would like to create a macro that changes the Note in a balloon based on some sort of rule.

 

My knowledge of VBA is very limited, and I would like to learn more based on this example.

 

Here's the case.

 

In a Drawing I have an X number of balloons.

The Balloons are placed automaticly and numbered from 1 to n

 

I need a script that does something like

 

For the active drawing

     lookup the first balloon you find

     read the note in that balloon

     change that note by comparing it to maybe an array

     next balloon

 

We need Letters in the balloons, so i want to replace 1 with A, 2 with B etc.

My idea was to create an array for this

 

something like

 

Dim Bchar(1 To n) As String

 

Bchar(1) = 'A'

Bchar(2) = 'B'

etc..

 

I found a script that walks through all Dimensions in a drawing.

How can I do the same but with balloons and then read the note and change it.

 

Thanx

Outcomes