Results 1 to 20 of 36

Thread: Change Fill color using VBA in PowerPoint

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #6
    VBAX Sage
    Joined
    Apr 2007
    Location
    United States
    Posts
    8,895
    Location
    This is what you requested, but I'm not sure it's what you need

    where I want to change Blue color to any custom color.
    There were no blue shapes in your example, so I made them blue

    Capture.JPG

    Option Explicit
    
    Sub test()
          Dim hshp As Shape
          Dim osld As Slide
          Dim j As Long
          Dim r As Long
          Dim g As Long
          Dim b As Long
          r = InputBox("Please enter Red number in: RGB(red,green,blue)", "Change Top Shape Color", "068")
          g = InputBox("Please enter Green number in: RGB(red,green,blue)", "Change Top Shape Color", "114")
          b = InputBox("Please enter Blue number in: RGB(red,green,blue)", "Change Top Shape Color", "196")
          Set osld = ActivePresentation.Slides(1)
          On Error Resume Next
          For j = 1 To 10
              Set hshp = osld.Shapes("Heptagon" & j)
              If hshp.Fill.ForeColor.RGB = RGB(0, 0, 255) Then
                  hshp.Fill.ForeColor.RGB = RGB(r, g, b)
                  hshp.Fill.Solid
              End If
        Next j
        On Error GoTo 0
    End Sub
    Attached Files Attached Files
    Last edited by Aussiebear; 03-10-2025 at 07:04 AM.
    ---------------------------------------------------------------------------------------------------------------------

    Paul


    Remember: Tell us WHAT you want to do, not HOW you think you want to do it

    1. Use [CODE] ....[/CODE ] Tags for readability
    [CODE]PasteYourCodeHere[/CODE ] -- (or paste your code, select it, click [#] button)
    2. Upload an example
    Go Advanced / Attachments - Manage Attachments / Add Files / Select Files / Select the file(s) / Upload Files / Done
    3. Mark the thread as [Solved] when you have an answer
    Thread Tools (on the top right corner, above the first message)
    4. Read the Forum FAQ, especially the part about cross-posting in other forums
    http://www.vbaexpress.com/forum/faq...._new_faq_item3

Tags for this Thread

Posting Permissions

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