+ Reply to Thread
Results 1 to 2 of 2

Multi-Worksheet ActiveX Textbox to ActiveX Textbox Concatenate

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

    Question Multi-Worksheet ActiveX Textbox to ActiveX Textbox Concatenate

    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.


    Please Login or Register  to view this content.
    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.

  2. #2
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 2016 (Windows)
    Posts
    5,255

    Re: Multi-Worksheet ActiveX Textbox to ActiveX Textbox Concatenate

    This is really a case where posting a workbook would be helpful - you have specific names and objects, and reproducing those details is a barrier to trying to help.
    Bernie Deitrick
    Excel MVP 2000-2010

+ 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 BackColor
    By heather1209 in forum Excel General
    Replies: 6
    Last Post: 06-04-2014, 11:53 AM
  2. ActiveX Textbox to ActiveX Textbox Concatentate
    By HVE_Skynet in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-17-2014, 05:22 PM
  3. ActiveX - TextBox
    By hmgrts in forum Excel General
    Replies: 3
    Last Post: 03-10-2013, 08:44 PM
  4. TextBox (ActiveX).Value
    By way2suresh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2013, 05:35 AM
  5. [SOLVED] ActiveX TextBox Height
    By zplugger in forum Excel General
    Replies: 2
    Last Post: 01-17-2013, 10:00 AM

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