+ Reply to Thread
Results 1 to 6 of 6

VBA Concatenation, Do not display tags on blank fields

  1. 01-13-2017, 11:25 AM #1
    pjbassdc
    pjbassdc is offline
    Forum Contributor
    Join Date
    05-12-2009
    Location
    Hendersonville, TN
    MS-Off Ver
    Excel 2010
    Posts
    113

    VBA Concatenation, Do not display tags on blank fields

    Hi All,

    I have been stumped on this for a while now. I have a userform that pushes data to a logsheet. I am combining the data to be displayed in a single cell on the log. My issue, I would like my "tags" to not display if there are no values attached. I am not sure what to do with my code from this point. Here is a sample image of what is being displayed.

    Capture.JPG

    I am unsure how it prevent the mA L, mA R from being displayed when nothing is in front of it. Could someone please help me with my code for this?

    Please Login or Register  to view this content.
    Thank you,

    Patrick
    Reply With QuoteRegister To Reply
  2. 01-13-2017, 11:26 AM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: VBA Concatenation, Do not display tags on blank fields

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 01-13-2017, 02:33 PM #3
    pjbassdc
    pjbassdc is offline
    Forum Contributor
    Join Date
    05-12-2009
    Location
    Hendersonville, TN
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: VBA Concatenation, Do not display tags on blank fields

    Thank you for the reply. The control for the data I am inquiring about is activated after T-EMG (Pedicle Screw) is selected in the "Monitored Modalities" check listbox. It should open up "Pedicle Screw Testing Data" on the userform. The code that needs some work is attached to CommandButton3_Click event. please let me know if I need to provide more data. The Running_Log worksheet has some data in column W with my remarks in Column X.


    Patrick
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 01-18-2017, 06:14 PM #4
    pjbassdc
    pjbassdc is offline
    Forum Contributor
    Join Date
    05-12-2009
    Location
    Hendersonville, TN
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: VBA Concatenation, Do not display tags on blank fields

    Anyone care to take a stab at this one? I am still looking for help.

    Patrick
    Reply With QuoteRegister To Reply
  5. 01-19-2017, 09:28 AM #5
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,480

    Re: VBA Concatenation, Do not display tags on blank fields

    If I make a userform with 6 textboxes, and name each textbox "TxtYou1","TxtYou2", etc.

    I would then loop through the textboxes and if there is a value, include it in the string, if not, just move on to the next textbox.

    Maybe practice with this, then see if you can use it in your userform

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  6. 01-31-2017, 11:59 AM #6
    pjbassdc
    pjbassdc is offline
    Forum Contributor
    Join Date
    05-12-2009
    Location
    Hendersonville, TN
    MS-Off Ver
    Excel 2010
    Posts
    113

    Re: VBA Concatenation, Do not display tags on blank fields

    Sorry it has been a while since I have been able to look at my project. I will try your suggestion. Thank you. I'll post back if I can get it to work for my situation.

    Patrick
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA Autofitler multiple cell/ fields partial str match, treat blank fields as any results
    By sdl2 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-21-2014, 10:00 PM
  2. Display message box with cell fields if they are blank
    By navytech79 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-03-2014, 06:37 AM
  3. Concatenation of numbers and text but only to display certain values?
    By alcorp in forum Access Tables & Databases
    Replies: 1
    Last Post: 08-19-2014, 08:20 PM
  4. Search multiple fields for text when all but 1 are blank, and display that cell's text
    By joshz2012 in forum Excel General
    Replies: 11
    Last Post: 11-03-2013, 09:16 PM
  5. [SOLVED] Vertical Concatenation with Tags
    By gokzee in forum Excel General
    Replies: 2
    Last Post: 03-28-2013, 02:04 AM
  6. Display Blank Fields As Blanks
    By arturo5 in forum Excel General
    Replies: 3
    Last Post: 03-20-2013, 10:46 AM
  7. Concatenation and skipping blank cells
    By soma104 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-31-2006, 08:15 AM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1