Results 1 to 2 of 2

Thread: Excel VBA creates PowerPoint Table - how to control bullet points?
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2011
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel VBA creates PowerPoint Table - how to control bullet points?

    Right now I have code that creates a table in PowerPoint 3 rows x 2 columns. This is created from a worksheet in Excel, by copying a 2x3 range of cells. Within each cell are multiple lines of text. The problem I face is that the text in PowerPoint needs to be bulleted. I used the following code:
    Code:
    With oTbl.Cell(lRow, lCol).Shape.TextFrame.TextRange
    .Character = 8226
    End With
    It works, except only the first line of each frame is bulleted. I guess it is treating the carriage returns as, well, carriage returns. Is there a way to overcome this? When I search for vbCrLf, nothing is returned.

  2. #2
    MrExcel MVP
    Join Date
    Mar 2004
    Location
    Canada
    Posts
    18,881
    Post Thanks / Like
    Mentioned
    38 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Excel VBA creates PowerPoint Table - how to control bullet points?

    Try searching for vbVerticalTab and replacing with vbCr, and then apply the bullets.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •