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.
Special Thanks to forum user Kenneth Hobson for his previous assistancePlease Login or Register to view this content.
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.
Bookmarks