Textbox object does not update
 

Excel 2000
I have textboxes that are linked to a named range cell in a different
worksheet in the same workbook. when the named range cell is updated, the
textbox value does not change. Is there a way to programmatically force the
text box to refresh?

cheers jay