+ Reply to Thread
Results 1 to 5 of 5

Formatting through array + adding bullet points

  1. #1
    Forum Contributor
    Join Date
    07-24-2024
    Location
    Canada
    MS-Off Ver
    365
    Posts
    127

    Formatting through array + adding bullet points

    Hi,

    Workbook : test_savedocx.xlsb

    I am looking to create an array or multiple array for case sensitive formatting.

    In the sample workbook above. WORD has different font color, but word does not. I wish to create an array, because I will be adding multiple word for formatting.

    Another example is TEXT is in bold letters. So I am guessing I will need a second array for this.

    My second issue is that when I click "Save docx", • which is alt-0149 does not appear as bullet points in word. I must select the text and select the Bullets option, and only then it shows as real bullet points. If this should be in the Word forum, although it is an excel file, please let me know.

    Thank you.

  2. #2
    Forum Contributor
    Join Date
    07-24-2024
    Location
    Canada
    MS-Off Ver
    365
    Posts
    127

    Re: Formatting through array + adding bullet points

    Bumping my thread, as I am still looking for a solution to this.

  3. #3
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,543

    Re: Formatting through array + adding bullet points

    Seek and you shall find. Ask and it will be given to you.
    You only need one table to control the properties. Replacing bullet points requires a separate approach.
    See attachment.

    Artik
    Attached Files Attached Files

  4. #4
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,378

    Re: Formatting through array + adding bullet points

    Hey MasterBash,

    Have you tried UniCode instead of Code for the 149? Maybe UniCode 8226?
    Also some font sets have different characters for these "funny" symbols.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  5. #5
    Forum Contributor
    Join Date
    07-24-2024
    Location
    Canada
    MS-Off Ver
    365
    Posts
    127

    Re: Formatting through array + adding bullet points

    Thank you so much Artik ! That is a much better solution than I initially had in mind.

    I played with it a lot and it works very well.

    Marvin, all is good ! Thanks to Artik, they appear as bullet points now.

+ 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] New bullet points keep adding to my first value
    By VBANewbie2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-27-2021, 09:11 AM
  2. Bullet points
    By drew.parker in forum Excel General
    Replies: 1
    Last Post: 03-08-2018, 04:26 PM
  3. bullet points in excel
    By annux08 in forum Excel General
    Replies: 1
    Last Post: 07-17-2015, 08:59 AM
  4. Bullet point and sub bullet points with numbers
    By trumpetman in forum Word Formatting & General
    Replies: 3
    Last Post: 12-17-2012, 12:23 PM
  5. bullet points on the toolbar
    By Jim in forum Excel General
    Replies: 1
    Last Post: 02-03-2006, 01:50 PM
  6. [SOLVED] bullet points
    By Shooter in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2005, 06:06 PM
  7. [SOLVED] Bullet Points in Excel
    By Cretin in forum Excel General
    Replies: 2
    Last Post: 04-05-2005, 12:06 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