My original problem, which was solved by Kenneth Hobson, I needed to concatenate two ActiveX text boxes together. It was for a spreadsheet to track server data and domain data.


Private Sub TextBox2_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
 If KeyCode = 13 Then ChangeTextBox1  'Enter Key was pressed.
End Sub

Sub ChangeTextBox1()
  TextBox1.Value = Split(TextBox1.Value, ".")(0) & "." & TextBox2.Value
End Sub

Private Sub TextBox2_LostFocus()
  ChangeTextBox1
End Sub
Special Thanks to forum user Kenneth Hobson for his previous assistance


However, I have run into a small issue with using it that I'm not that skilled at altering the syntax of the code. I've tried to use ActiveSheet and Worksheet("Name") commands, but I cant get my version of the altered code to do what I need. I feel as though there is an easier way to accomplish this task, but the solution eludes me.


Nonetheless, could someone please point me in the right direction so that I can "link" two ActiveX Textboxes in the same Workbook, but in separate worksheets? To help explain further, see below:


Worksheet Project Details has an ActiveX textbox "CustomerName"
The "CustomerName" ActiveX textbox needs to share the data inputed on the Project Details worksheet with the Network Setup worksheet, which contains the "NetSetCustName" ActiveX textbox.