Hi
Put your workbook into design mode
Choose View, Toolbars, Control ToolBox.
On your Control Toolbox Menu, choose the design triangle.(probably in the upper-left corner)
Double-click your textbox.
Note the name of your textbox in the upper left corner of the new window.
Close the window.
Also note the name of your active worksheet on the worksheet tab.
Now go to the sheet containing the second text box.
Double-click on this textbox and a window should pop up. This is the code module for your worksheet. The "Change" event should be on your screen already, if not, choose it by clicking the combo box on the upper right.
Type this inside the change sub procedure
Sheets("YourOtherSheetName").TextBoxNameOnFirstSheet.Text = CurrentTextBoxName.Text
Should look something like this:
Private Sub TextBox1_Change()
Sheets("Sheet1").TextBox1.Text = TextBox1.Text
End Sub
Repeat this process for the other sheet.
If you cannot accomplish what you need done
with the following instruxtions then post the following:
SheetName 1
Textbox Name 1
SheetName 2
Textbox Name 2
Thanks,
Tom
This message was edited by TsTom on 2002-04-07 13:53