Hello Ed,

To reset the Text Boxes' text (address), we can use the macro:

Sub SetTBtext(sAddress As String)
For Each ws In ActiveWorkbook.Worksheets
For Each tb In ws.TextBoxes
tb.Text = sAddress
Next
Next
End Sub

Then run the macro from a VB.NET program:
http://support.microsoft.com/kb/306682

or we can write a VB.NET automation client to run the code directly:
http://support.microsoft.com/kb/301982

Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.