Results 1 to 6 of 6

changing size of autoshape

Threaded View

  1. #1
    Registered User
    Join Date
    02-01-2005
    Posts
    62

    Question changing size of autoshape

    Trying to do some basic animation with an autoshape. I have a rectangle that I am changing the size in steps. The problem is, it resizes the bottom edge of the rectangle up instead of moving the top edge of the rectangle down.

    here is my code:
    For j = 1 To 200
    rectheight = rectheight - 0.5
    ActiveSheet.Shapes("Rectangle 1").Height = rectheight
    For i = 1 To 100
    DoEvents
    Next i
    Next j
    How do I tell VBA to resize my rectangle from the top down?
    Last edited by grime; 01-25-2006 at 11:47 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