+ Reply to Thread
Results 1 to 4 of 4

VBA populates cell with text some bold

  1. #1
    Registered User
    Join Date
    02-11-2016
    Location
    Wisconsin
    MS-Off Ver
    07-360
    Posts
    53

    VBA populates cell with text some bold

    Hi, I am wondering if there is a good way to have some text in a cell (populated by vba) to be bold and others not. The code I am using to populate the cell is:

    Please Login or Register  to view this content.
    I would like to have everything in quotes bold were as the textbox values should not be.
    Please Login or Register  to view this content.
    I cannot have code that searches for the text to be bold as it will also likely show in the textbox values as well
    Sorry if this is a no brainer, I am teaching myself VBA and couldn't find anything to meet my needs in the search. Thanks!

  2. #2
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: VBA populates cell with text some bold

    When you say you can't use a search function because the values will show in the textbox values, do you mean that "Programming: " in its entirely will recur from one of the textboxes?

    If that is true, you can still add in obscure characters for this exact purpose. I arbitrarily chose Alt+246 "÷" because I use it often, use whatever floats your boat.


    Please Login or Register  to view this content.

    Let's pretend this will populate A1.

    Please Login or Register  to view this content.
    The process we use to bolden certain parts, we can use to white-out the special character we use to find them.
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: VBA populates cell with text some bold

    Here's a sample with the completed code so you can see the implementation.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-11-2016
    Location
    Wisconsin
    MS-Off Ver
    07-360
    Posts
    53

    Re: VBA populates cell with text some bold

    Thanks!! That did the trick! I was kind of expecting something like html but that I didn't think about throwing in something random and hiding it. This would be so much easier if you could just (b) (/b). thanks again

+ 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. Input text in one cell and it populates another cell with different text
    By roseyj in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-11-2016, 03:13 AM
  2. [SOLVED] Copy any bold text within a cell text string to an adjacent cell
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-31-2014, 06:22 PM
  3. Text Box that opens when cell is click and populates based on a lookup
    By Whirlpool in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2013, 07:55 AM
  4. Split cell - bold text and non bold text.
    By desertshift in forum Excel General
    Replies: 10
    Last Post: 11-21-2010, 08:13 PM
  5. Delete all text which is not 'bold' in cells with 'mingled bold' text
    By Excelfriend in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2010, 04:47 PM
  6. Replies: 2
    Last Post: 09-10-2009, 05:40 AM
  7. Join bold and non-bold text in one cell
    By bkincaid in forum Excel General
    Replies: 3
    Last Post: 03-20-2006, 09:10 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