+ Reply to Thread
Results 1 to 6 of 6

VBA to concatenate filtered columns, with different bold and font size formats

  1. #1
    Registered User
    Join Date
    01-27-2021
    Location
    atlanta
    MS-Off Ver
    365 (Enterprise)
    Posts
    24

    VBA to concatenate filtered columns, with different bold and font size formats

    Hi there, I'm developing a file that uses the filter function to list lines of data (names, title, etc.) based on a condition, and then off to the side use concatenate to combine 7 columns into different lines (using char(10) to enter each into a new line). But I also want to bold the name and change the font size to Arial 20, while the other text stays Arial 14 and not bolded. From reading around, it seems impossible to do this with concatenate but maybe with VBA?
    So instead of:



    I've seen an example for doing this below but it's based on an exact string. How can I change this to concatenate data from columns, especially those that are auto populated from a filter function? Thanks for any guidance

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by beginner21; 04-25-2021 at 12:27 PM. Reason: change tite

  2. #2
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: VBA to concatenate filtered columns, with different bold and font size formats

    Hi beginner21,

    Try below code, it will insert the results of CONCAT function in column U & it will make "Worker 1" bold & size 20 ... If this is what you're looking for, we can make adjustments if needed ...

    Please Login or Register  to view this content.
    If I was able to help, you can thank me by clicking the * Add Reputation under my user name

  3. #3
    Registered User
    Join Date
    01-27-2021
    Location
    atlanta
    MS-Off Ver
    365 (Enterprise)
    Posts
    24

    Re: VBA to concatenate filtered columns, with different bold and font size formats

    Hi nankw83, that worked perfectly! Thank you! Only adjustments are that I want the name to be bolded and bigger, so "A" instead of Worker 1. Will I make that change with the Len functions?

  4. #4
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: VBA to concatenate filtered columns, with different bold and font size formats

    If you want "A" instead of "Worker 1" just change the below line
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-27-2021
    Location
    atlanta
    MS-Off Ver
    365 (Enterprise)
    Posts
    24

    Re: VBA to concatenate filtered columns, with different bold and font size formats

    That worked perfectly! Thank you!

  6. #6
    Forum Expert nankw83's Avatar
    Join Date
    08-31-2015
    Location
    Kuwait
    MS-Off Ver
    365
    Posts
    1,709

    Re: VBA to concatenate filtered columns, with different bold and font size formats

    Glad to help & thanks for the Rep+

    If that takes care of your question, please take a moment & mark this thread as [SOLVED] from the Thread Tools above your first post

+ 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. Replies: 2
    Last Post: 10-25-2022, 08:06 PM
  2. [SOLVED] Change font size and bold active row
    By sick stigma in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2020, 10:01 AM
  3. [SOLVED] Userform Label property (Font size and bold)
    By niuyuer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-04-2017, 03:43 PM
  4. New thread for font size & bold
    By EMoe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2008, 11:24 PM
  5. How to change font size & bold
    By EMoe in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-03-2008, 12:52 AM
  6. Can you keep a cells BOLD Font, cell color size
    By Trese in forum Excel General
    Replies: 2
    Last Post: 08-23-2005, 11:05 AM
  7. Dropdown list for font size, font type and number formats
    By ExcelMonkey in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-09-2005, 01:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1