View Full Version : TextBox Challenge

11-02-2012, 07:21 AM
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,


11-04-2012, 07:34 PM
With VBA you don't need the placeholder, just build the string and insert it into the .Text property of the TextBox. Such as:

msgText = NameTextBox.text & " is currently " & NameTextBox.text & _
"years old"
ObjectiveTextBox.text = msgText