+ Reply to Thread
Results 1 to 5 of 5

VBA to underline and bold

  1. #1
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    VBA to underline and bold

    How would I alter this code to also underline as well.

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: VBA to underline and bold

    Copy the lines that set the Bold attribute and replace 'Bold' with 'Underline'...

  3. #3
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: VBA to underline and bold

    I want them to be BOTH bold and underlined. That's my problem. (Well i have a lot of problems... HA)

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: VBA to underline and bold

    You're making this a lot more difficult that what it is. Try this:

    Find the first line that refers to the Bold attribute. Copy that line, add a new blank line immediately below and paste to the newly added blank line. Replace any reference to 'Bold' in the new line with 'Underline'.

    Repeat until all lines that refer to Bold have been copied, pasted and edited.

  5. #5
    Forum Contributor
    Join Date
    05-05-2004
    MS-Off Ver
    Office 365
    Posts
    651

    Re: VBA to underline and bold

    Yep. I see what you mean. Thanks!

+ 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. [SOLVED] I want bold underline specified formula value in a paragraph. need vba
    By vengatvj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-10-2016, 01:30 PM
  2. Need Help - Auto Bold & Underline
    By chengp in forum Excel General
    Replies: 3
    Last Post: 03-15-2016, 12:20 PM
  3. [SOLVED] Need to 'Bold' & 'Underline specific characters in a field
    By KatieKat440 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 03-19-2013, 03:57 PM
  4. Formula That Recognizes Bold or Underline
    By par5nto in forum Excel General
    Replies: 3
    Last Post: 10-24-2011, 09:20 AM
  5. selecting cells also selects bold, underline
    By Mickmac in forum Excel General
    Replies: 2
    Last Post: 05-23-2011, 05:20 AM
  6. Bold, Underline and Italic greyed out
    By drgogo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-08-2009, 09:30 AM
  7. [SOLVED] bold italics or underline
    By Dorothy in forum Excel General
    Replies: 5
    Last Post: 02-16-2005, 11:28 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