TextBox Challenge

Hi, so I'm trying to create some sort of report generator.

It has a multipage and on the first tab it would request for inputs such as Names, Age etc.

On second tab, it has a Objective textbox. So my question is how can I do, for example putting a placeholder "%Name% is currently %Age% years old" in the Objective textbox ?

Is this possible ? Thanks,

Regards,
Arbitel

With VBA you don't need the placeholder, just build the string and insert it into the .Text property of the TextBox. Such as:

[vba]
msgText = NameTextBox.text & " is currently " & NameTextBox.text & _
"years old"
ObjectiveTextBox.text = msgText[/vba]