ActiveX Textbox to ActiveX Textbox Concatentate

Hello!


I have never had the need for a VBA / Excel forum before, so forgive me if I forget any details that may be needed for assistance. I've tried several ways to attempt to achieve my goal, but I finally conceded to ask for help



I have an Excel 2013 macro-enabled spreadsheet that I need to concatentate two ActiveX text boxes together. It's for a spreadsheet to track server data and domain data. Therefore, ActiveX TextBox located in cell A8 (we'll call it TextBox1) has the server name pre-populated because it never changes(we'll call it ServerName). The next ActiveX text box has the domain name (which changes site to site), but for the sake of simplicity, we'll call it DOMAINNAME.NET (TextBox2).


What I need is to concatentate TextBox1, so that when the DOMAINNAME.NET is changed to whatever the actual value is, TextBox1 will update and should show inside of the textbox ServerName.DOMAINNAME.NET as the value.



Can anyone shed any light or provide any assistance with accomplishing this? Thank you in advance!

Welcome to the forum!

Right click the sheet's tab, View > Code, and paste:

Please Login or Register  to view this content.

Kenneth,


You're amazing. Thank you for your assistance! It worked perfectly.

Okay, a follow-up question: (my apologies in advance)



I over-looked a small detail that the DOMAINNAME.NET change needs to be able to change more than one text box, so ActiveX TextBox1, 2, 3, 4, 5, 6 will need to be modified by DOMAINNAME.NET.


In an effort, not to bug you all again, I tried to just use the code again with some changes, but it only changes the first box and then you have to click each server name one at a time for it to realize that it needs to update.


Therefore, I need them all to update once you update the DOMAINNAME.NET ActiveX TextBox field.



Very sorry for the over sight, and thank you again for the prior assistance!

Does this not suffice?

Please Login or Register  to view this content.

I cant believe I over-looked that... ugh.


Again, Kenneth, you are a gentlemen and a scholar. I appreciate your assistance.

Several weeks later, I have come across a new problem related to this request. How can I alter the below code to link Textbox1 to Textbox2, but Textbox1 is located in Worksheet ABCD and Textbox2 is located in Worksheet EFGH?

Please Login or Register  to view this content.

Thank you in advance.