VBA - Text Boxes

Reading Writing Text

When you read text from a textbox additional characters will be included in your text string.

Any spaces are represented by Chr(32)
At the end of the text there will also be a Chr(13)
To remove the carriage return at the end of the string you need to include the following:

Text boxes cannot have the same name if you are renaming using VBA
However testboxes with the same name can be inserted by inserting the same building block multiple times

The following line of code does not include any shapes in the headers or footers

Adds a text box to a drawing canvas.

Add the Title text box

Size the text in a textbox to fill the textbox