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
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
Dim Bchar(1 To n) As String
Bchar(1) = 'A'
Bchar(2) = 'B'
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.