+ Reply to Thread
Results 1 to 2 of 2

If IsEmpty - Copying Text from Multiple Text Boxes to 1 Text Box

  1. #1
    Registered User
    Join Date
    02-10-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    33

    If IsEmpty - Copying Text from Multiple Text Boxes to 1 Text Box

    Hi,

    I have a form that has 5 small text boxes and a big text box. What i am trying to do is add value in required text boxes and when i say record the Text box values should be copied to the big text box.
    I have the following code:
    Please Login or Register  to view this content.
    and i am getting this in the big text box:

    Name

    Bob
    ====================
    DOB


    ====================

    Address

    1212 Tom Street, ABC Avenue, Sussex, NB - 101010
    ====================

    i have not entered any Data Under DOB but on the Big text box i am getting the Header DOB and i dont want the Caption also to come. If there is a value in the text box then in the big text box the value should come along with the caption"Name" or "DOB".

    Any help would be highly appreciated.
    Attached Files Attached Files
    Last edited by AliGW; 10-30-2018 at 02:08 AM. Reason: Don't forget code tags!

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,644

    Re: If IsEmpty - Copying Text from Multiple Text Boxes to 1 Text Box

    Try this.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

+ 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. Replacing specific text in multiple text boxes based on cell values
    By ettevi23 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-17-2017, 09:21 PM
  2. Replies: 1
    Last Post: 02-19-2014, 10:04 PM
  3. [SOLVED] Text Boxes: Insert/Text Box vs. Developer Text Boxes
    By snapfade in forum Excel General
    Replies: 5
    Last Post: 10-09-2012, 01:45 AM
  4. Macro to Parse Text - Import text to Excel from Multiple Text Files & Folders
    By Novice_To_Excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-02-2012, 01:05 AM
  5. Copying text from text boxes
    By johngr55 in forum Excel General
    Replies: 3
    Last Post: 05-09-2010, 05:06 PM
  6. Replies: 2
    Last Post: 02-19-2010, 03:55 PM
  7. Copying text to password boxes
    By neeraj in forum Excel General
    Replies: 3
    Last Post: 09-21-2005, 02:05 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