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!