Hi all,

I managed to create a sub that allows me to change text in the header of word documents. We moved address in work and there were so many to change, I decided to write the routine.

Now I need to use it on another set of letters in the same way.

Unfortunately all it does is swap text in the textbox shape.
Now I need to add an extra line. I believe I could do that with vbCRLF and with some text. However my manager wants to also enlarge the font from 8 to 10, and this then exceeds the size of the text shape.

So I believe I need to somehow change the size of the text shape, but cannot find the method/properties to do it.? I've looked at MarginTop, Autosize etc.


The text shape is also going to have to move to the left to accommodate the larger size and the header depth is also going to have to grow to accommodate the text box.

Would anyone be able to tell me the properties I could use to do the above please.?

TIA