Hi

I wonder if someone can help me. I am using Excel 97 and I've got a
textbox on the worksheet that I want to be filled with information on a
cell on another sheet. How would I reference this in VBA so that the
textbox was updated every time the sheet was activated?

I had looked on the web and found one way to do it, but it was a textbox
from the Drawing menu not the Control Toolbox menu, and it didn't have
scroll bars, which it needs to have.

So, I've got in VBA:

txtMessages.Text =

but I don't know how to reference the cell.

Thanks in advance.
--
Charles