+ Reply to Thread
Results 1 to 7 of 7

ActiveX Textbox to ActiveX Textbox Concatentate

  1. #1
    Registered User
    Join Date
    03-26-2014
    Location
    U.S.
    MS-Off Ver
    Excel 2013
    Posts
    6

    Question 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!

  2. #2
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,575

    Re: ActiveX Textbox to ActiveX Textbox Concatentate

    Welcome to the forum!

    Right click the sheet's tab, View > Code, and paste:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    03-26-2014
    Location
    U.S.
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: ActiveX Textbox to ActiveX Textbox Concatentate

    Kenneth,


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

  4. #4
    Registered User
    Join Date
    03-26-2014
    Location
    U.S.
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: ActiveX Textbox to ActiveX Textbox Concatentate

    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!

  5. #5
    Forum Expert Kenneth Hobson's Avatar
    Join Date
    02-05-2007
    Location
    Tecumseh, OK
    MS-Off Ver
    Office 365, Win10Home
    Posts
    2,575

    Re: ActiveX Textbox to ActiveX Textbox Concatentate

    Does this not suffice?
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    03-26-2014
    Location
    U.S.
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: ActiveX Textbox to ActiveX Textbox Concatentate

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


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

  7. #7
    Registered User
    Join Date
    03-26-2014
    Location
    U.S.
    MS-Off Ver
    Excel 2013
    Posts
    6

    Unhappy Re: ActiveX Textbox to ActiveX Textbox Concatentate

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. ActiveX Textbox Shrinking!
    By mrr2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-25-2013, 05:30 PM
  2. ActiveX - TextBox
    By hmgrts in forum Excel General
    Replies: 3
    Last Post: 03-10-2013, 08:44 PM
  3. TextBox (ActiveX).Value
    By way2suresh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 05:35 AM
  4. [SOLVED] ActiveX TextBox Height
    By zplugger in forum Excel General
    Replies: 2
    Last Post: 01-17-2013, 10:00 AM
  5. Refreshing activex textbox
    By geoB in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-06-2009, 05:58 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1