Right click on the text box and select properties. In the propertydisplay set the attribute CONTROLSOURCE to the cell in the worksheetyou are interested in. You may wish to name this cell and then referto the name in CONTROLSOURCE