Consulting

Results 1 to 2 of 2

Thread: VBA how do you change the thickess of a line using AddLine

  1. #1

    VBA how do you change the thickess of a line using AddLine

    This code works fine to change the colour of a line

    With ActiveSheet.Shapes.AddLine(pAx, pAy, pBx, pBy).Line
    .ForeColor.RGB = RGB(250, 0, 0)
    End With

    but what syntax do I need to change the thickness of the line.

    I have looked but cannot find anywhere that lists all the options for the AddLine command - Any suggestions

    AQ

  2. #2
    Try
    ShapeRange.Line.Weight = 2.5
    In your case it would be
    With ActiveSheet.Shapes.AddLine(pAx, pAy, pBx, pBy).Line
    .ForeColor.RGB = RGB(250, 0, 0)
    .Weight = 3.5
    End With

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
  •