Results 1 to 3 of 3

Add shape without selecting worksheet or cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-31-2010
    Location
    Castro Valley, CA
    MS-Off Ver
    Excel 2003
    Posts
    6

    Add shape without selecting worksheet or cell

    Hi
    The following code works well in circling [actually an oval around] a cell - but I haven't been able to figure out how to add a shape without selecting the sheet and a cell. I'm assuming this is possible and I'm missing the obvious. Any help would be appreciated. Thanks.
    Richard

    CompletedChecklistForm.Select
      CompletedChecklistForm.Range(ptrChecklistFormQCurrent). _
    Offset(0, (NewQuestionNumberNewAnswerNumber - 1) * 4).Select
            With ActiveSheet.Shapes.AddShape(msoShapeOval, 135.75, 112.5, 7.5, 7.5)
                        .Fill.Visible = msoFalse
                        .Top = ActiveCell.Top
                        .Left = ActiveCell.Left
                        .Width = ActiveCell.Width
                        .Height = ActiveCell.Height
            End With
    SheetChecklistUserEntry.Select
    Last edited by rgarber; 08-09-2010 at 01:33 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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