Hello all,

I have 2 sheets (Sheet 1 and Sheet 2) in my workbook. In Sheet 2, I want to
create a text box, and I want the text box to show the student name (e.g.
Student Name - Joe Smith) from Sheet 1.

So I type in the formula (="Student Name - " & 'Sheet 1'!A1) in the Text
field properties of the the text box. Some how, the text box shows the
formula, instead of "Student Name - Joe Smith" (Joe Smith is a value in A1 of
Sheet 1).

Please help.

Thanks.