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!

Trent