AnsweredAssumed Answered

Macro to change balloon text from one text to another?

Question asked by Trent Baptiste on Jun 14, 2019
Latest reply on Aug 23, 2019 by Ravi Chandra Verma

Hi all,


I'm fairly new to VBA, sorry if this is an easy one! I am trying to convert the text of balloons from one text to another using a macro, but only for specific balloons (see below). I have hundreds of drawings, so it makes sense to try to write a macro.


I want to rename the balloons that have text $PRPMODEL:"ItemName" and rename them to $PRPMODEL:"ItemNumber". Some balloons have manually entered text for item numbers, so I can't rename all balloons to the $PRPMODEL:"ItemNumber" text. 


Not sure if this matters, but some of the balloons that need changed will be stacked together. 


There can also be multiple sheets of the drawing where balloons will need changed.


Thanks for the help!